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. |
=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 04:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com