ExcelBanter - Count number of cells with date <today's date

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

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Count number of cells with date <today's date (https://www.excelbanter.com/new-users-excel/67863-count-number-cells-date-todays-date.html)

Cachod1

Count number of cells with date <today's date

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"

Bob Umlas

Count number of cells with date <today's date

=COUNTIF(B1:B100,"<"&TODAY())
Bb Umlas
Excel MVP
"Cachod1" wrote in message
...
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"

JMB

Count number of cells with date <today's date

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

"Cachod1" wrote:

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"

All times are GMT +1. The time now is 07:36 AM.