Hi,

Your formula would look like this

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Lynz" wrote:

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.