| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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" |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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" |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Seed date formats to different year in different cells | Excel Discussion (Misc queries) | |||
| Can I count how many grey-filled cells are in a row ? | Excel Worksheet Functions | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
Linear Mode
