I Need to Count a Date

[BYates123]

This shouldn't be too difficult but I can't figure it out:

I have a list of dates that read examples such as "1/3/1900" and "4/16/2004". I want to count all of the cells that contain "1900". I tried =COUNTIF(A1:A10,"*1900"), which I thought would work, but it returned a value of 0. What should I do?

 

[VoG]

Try

=SUMPRODUCT(--(YEAR(A1:A10)=1900),--(A1:A10<>""))

 

[T. Valko]

This shouldn't be too difficult but I can't figure it out:

I have a list of dates that read examples such as "1/3/1900" and "4/16/2004". I want to count all of the cells that contain "1900". I tried =COUNTIF(A1:A10,"*1900"), which I thought would work, but it returned a value of 0. What should I do?

One way...

=SUMPRODUCT(--(YEAR(A1:A10)=1900))

Assumes there are no empty cells and no text entries in the range.

 

[BYates123]

Thanks a lot that seemed to work. I also need to count the dates before today in a certain range...would I use SUMPRODUCT for that as well?

 

[VoG]

That's a bit easier

=COUNTIF(A1:A10,"<"&TODAY())

 

[T. Valko]

Thanks a lot that seemed to work. I also need to count the dates before today in a certain range...would I use SUMPRODUCT for that as well?

Before today means less than today.

Try this:

=COUNTIF(A1:A10,"<"&TODAY())