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