D
Dilly
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))
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))