I have 1000+ records over 4 years & want to count how many for each month &
year ie May 2005. Records have specific days 4 May 2005
I can use :
=SUMPRODUCT(--(YEAR(c2:c1000)=2005),--(MONTH(c2:c1000)=4)) to pick up
individual month year, but I want to make life easier & not type in each year
& month (4 years x 12 months & growing!)
Any advice

Saintsman