Dee,

Try

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

--
HTH

Bob Phillips

"Dee" wrote in message
...
I have a sheet with dates and I want to count the cells that have a date
that
is less than or equal to today. The formula I entered was countif(A1:G1,
"<=TODAY()") I keep getting 0 when there are dates in these cells that are
less than or equal to today's date. Could someone tell me what I am doing
wrong. I am using Excel 2003.

Thanks very much for your help.

Best regards,

Dee