Counting dates before today

[Lynz]

Hi, I have a list of dates in column E4:E38 ranging from 14/2/09 to
14/4/09 some of which occur more than once. What I would like to do is
count how many occurrences there are of dates previous to and including
today including the duplicates etc. I have tried countif and counta but
dont seem to be able to get the right formula. I have (today) in A2.
Thank you for any help with this.

 

[T. Valko]

Try this:

=COUNTIF(E4:E38,"<="&TODAY())

 

[Shane Devenshire]

Hi,

Your formula would look like this

=COUNTIF(E4:E34,"<="&A2)

 

[Lynz]

Try this:

=COUNTIF(E4:E38,"<="&TODAY())

THank you so much that works great. I had () and"" in the wrong places.
HAve a nice day
L

 

[Lynz]

Hi,

Your formula would look like this

=COUNTIF(E4:E34,"<="&A2)

Thanks Shane

 

[T. Valko]

You're welcome. Thanks for the feedback!

 

[Shane Devenshire]

Hi,

Your welcome.