| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
count the number of cells with a date <= today's date
I need to count the number of cells in a column that contain a date that is
<= today's date. I've tried using a COUNTIF formula but it's not working. HELP! |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
count the number of cells with a date <= today's date
If the data is in cells A1:A3
=COUNTIF(A1:A3, "<="&TODAY()) "Cachod1" wrote: I need to count the number of cells in a column that contain a date that is <= today's date. I've tried using a COUNTIF formula but it's not working. HELP! |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
count the number of cells with a date <= today's date
This formula will also count any other number that is NOT a date, as though
it WAS a date............ Vaya con Dios, Chuck, CABGx3 "JMB" wrote: If the data is in cells A1:A3 =COUNTIF(A1:A3, "<="&TODAY()) "Cachod1" wrote: I need to count the number of cells in a column that contain a date that is <= today's date. I've tried using a COUNTIF formula but it's not working. HELP! |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
count the number of cells with a date <= today's date
=SUMPRODUCT(--(A2:A200<""),--(A2:A200<=TODAY()))
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Cachod1" wrote in message ... I need to count the number of cells in a column that contain a date that is <= today's date. I've tried using a COUNTIF formula but it's not working. HELP! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sum a range if the date is is greater than today's date? | Excel Worksheet Functions | |||
| how to count number of cells in a color ? | Excel Discussion (Misc queries) | |||
| How do I count the number of cells in a list, e.g. H6:H12, J4, J7: | Excel Worksheet Functions | |||
| Count cells based on date range in another column | New Users to Excel | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
Linear Mode
