| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Dates - Not Text
Hi,
I'm trying to count the number of "date" occurrences on a particular month. However in the same column, aside from dates, there are TEXT entries and blank cells. When I use the formula below it gives me a #VALUE! Please edit the formula below so I can count the number of date occurences. =SUMPRODUCT(--(MONTH('Date'!J2:J1116)=1)) Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Dates - Not Text | Excel Worksheet Functions | |||
| Counting Dates - Not Text | Excel Worksheet Functions | |||
| Counting Dates | Excel Discussion (Misc queries) | |||
| counting occasions dates occur between 2 dates | New Users to Excel | |||
| Counting dates, within a list of dates | Excel Worksheet Functions | |||
Threaded Mode
