Count number of cells with date <today's date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cachod1 - 27 Jan 2006 17:24 GMT

I need to count the number of cells in one column that contain a date that is
<= today's date. The dates are currently formatted as "General" numbers
rather than being formatted as "Date"

Reply to this Message

Bob Umlas - 27 Jan 2006 18:53 GMT

=COUNTIF(B1:B100,"<"&TODAY())
Bb Umlas
Excel MVP

> I need to count the number of cells in one column that contain a date that is
> <= today's date. The dates are currently formatted as "General" numbers
> rather than being formatted as "Date"

Reply to this Message

JMB - 28 Jan 2006 02:37 GMT

Which of the four responses you've received thus far don't work???????????

> I need to count the number of cells in one column that contain a date that is
> <= today's date. The dates are currently formatted as "General" numbers
> rather than being formatted as "Date"

Reply to this Message