ExcelBanter - Why count if does not work

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Why count if does not work (https://www.excelbanter.com/excel-discussion-misc-queries/127454-why-count-if-does-not-work.html)

Esrei

Why count if does not work

I have a list of dates in clm A

I want to count the amount of dates that is smaler than today.

countif(A3:A19,"<today()")

gives me a 0 answer

Thank you

CLR

Why count if does not work

=COUNTIF(A:A,"<"&TODAY())

hth
Vaya con Dios,
Chuck, CABGx3

"Esrei" wrote in message
...
I have a list of dates in clm A

I want to count the amount of dates that is smaler than today.

countif(A3:A19,"<today()")

gives me a 0 answer

Thank you

All times are GMT +1. The time now is 04:41 AM.