Hi,

Can someone tell me if there is something wrong with the below function I'm using.. It keeps returning #VALUE!.

A2:A50 on the Weekly Stats sheet contain a date.. It's driving me nuts..
Using Excel 2007.

=SUMPRODUCT(--MONTH('Weekly Stats'!A2:A50)=1)