Countif Function

[Guest]

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

 

[Bob Phillips]

Dee,

Try

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

 

[Guest]

Thank you so much. It worked! All of you guys are so amazing. I have learned
so much from these newgroups. I don't know what I'd do without you guys.
Thanks again!