ExcelBanter - Count the number of dates in a range that are earlier than today.

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Count the number of dates in a range that are earlier than today. (https://www.excelbanter.com/excel-worksheet-functions/16765-count-number-dates-range-earlier-than-today.html)

DeborahS

Count the number of dates in a range that are earlier than today.

I need a formula to count the number of dates in a range that are earlier
than today. I've been trying to use countif, but can't get it to use both
the less-than < sign and the volitile today() function. Thanks in advance
for any help.

CLR

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

Vaya con Dios,
Chuck, CABGx3

"DeborahS" wrote in message
...
I need a formula to count the number of dates in a range that are earlier
than today. I've been trying to use countif, but can't get it to use both
the less-than < sign and the volitile today() function. Thanks in advance
for any help.

All times are GMT +1. The time now is 01:35 PM.