• Privacywetgeving
    Het is bij Helpmij.nl niet toegestaan om persoonsgegevens in een voorbeeld te plaatsen. Alle voorbeelden die persoonsgegevens bevatten zullen zonder opgaaf van reden verwijderd worden. In de vraag zal specifiek vermeld moeten worden dat het om fictieve namen gaat.

Datum velden optellen in excel

Status
Niet open voor verdere reacties.
M

masarada

Gebruiker
Lid geworden
6 nov 2007
Berichten
6
Hoi Allemaal

*My NL is not good, hope there would be some answers to this query :)

My sheet looks pretty much like this

1.png

I just want to add the 'occurrences' of the dates, for example in the image above -the red arrows shows the occurrences , and there are thus 4 of them ( 4 occurrences with red arrows).

what is a formula to calculate all the date occurrences on this sheet.


I tried:

1) =COUNT(A1:A76) , will give the total number , but then its also including the timestamps.


2) also tried : =COUNTIF(range, if_date()) , but no joy ( =COUNTIF(A1: A76, if_date()) ; where A1 to A76 is my range

would love to hear some suggestions here , if possible.

Thx.!
 
Try this one:
Code: 
=COUNTIF(A:A;">"&1)
 
Laatst bewerkt:
Try this:
=COUNTIF(A1:A76,">=1/1/00")

Please note that the value in A1 is not a real date but a text string.
 
Laatst bewerkt:
edmoor zei:
Try this:
=COUNTIF(A1:A76,">=1/1/00")

Please note that the value in A1 is not a real date but a text string.
Klik om te vergroten...

Thanks,

I tried the above, but somehow it will not accept it . ( I have excluded A1 from the range, since its a text string)

1.png

Thx. for any assistance.
Cheers
 
Code: 
=COUNTIF(A1:A76[COLOR="#FF0000"];[/COLOR]">=1/1/00")

Try this
 
Excellent !:thumb:

Bedankt ! opgelost :) & Thanks to All !
 
Laatst bewerkt:
Ecrire la prochaine fois en Hollande et poser la question comme réglée.
 
masarada zei:
Thanks,

I tried the above, but somehow it will not accept it . ( I have excluded A1 from the range, since its a text string

Thx. for any assistance.
Cheers
Klik om te vergroten...

You might need to replace the , for a ;
But your problem is already solved :)
 
Status
Niet open voor verdere reacties.
Steun Ons

Nieuwste berichten

Terug
Bovenaan Onderaan