Try this:

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

--
Biff
Microsoft Excel MVP


"Lynz" wrote in message
...
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.