Countif Function
 

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

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

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!

"Bob Phillips" wrote:

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