count the number of cells with a date <= today's date
This formula will also count any other number that is NOT a date, as though
it WAS a date............
Vaya con Dios,
Chuck, CABGx3
"JMB" wrote:
If the data is in cells A1:A3
=COUNTIF(A1:A3, "<="&TODAY())
"Cachod1" wrote:
I need to count the number of cells in a column that contain a date that is
<= today's date. I've tried using a COUNTIF formula but it's not working.
HELP!
|