Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to assist with counting dates
I am using the formula below to count the number of dates in a certain month
and year from a random list of dates. However my "list" of dates is not a continuous string of dates and is split by some text and some headings. When i use this formula it highlights a value error. Is their any way around this ?? =SUMPRODUCT(--(MONTH(A1:A100)=2),--(YEAR(A1:A100)=2009)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to assist with counting dates | Excel Discussion (Misc queries) | |||
Formula to assist with Counting Dates | Excel Discussion (Misc queries) | |||
Need Assist With Formula Creation | Excel Worksheet Functions | |||
Assist with Match Dates | Excel Discussion (Misc queries) | |||
Formula Assist | Excel Discussion (Misc queries) |