Morning All,
I have a list of dates in a column I need to know how many are from January,
February, March etc.
The formula I am currently using is
=SUMPRODUCT(--(MONTH(Rng)=1)),--(ISNUMBER(Rng)))
this works fine if all the dates are from one year eg all 2004, however I
now have data containing dates from 2004 and 2005.
How can I adapt the formula to distinguish btn Jan 2004 and Jan 2005?
TIA
Ajay