If the dates in ColA are in excel date format the below would work...

=COUNTIF(A:A,TODAY())

If this post helps click Yes
---------------
Jacob Skaria


"Derek M" wrote:

Hi All

need to match dates in a column of data to todays date, i.e.

3/11/09
4/11/09
5/11/09
5/11/09

If today is 5/11/09 then the cell would return the value 2, i cant figure
out the sum :)

Thanks for any help in advance

Derek