=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.
|