With the month number in A1
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(DATE(YEAR(TODAY()),A1,1)&":" &DATE(YEAR(T
ODAY()),A1+1,0))))=1))
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Sunday Function" <Sunday
wrote in
message ...
Please help me with formula to count : Sundays or Weeks per Month (Year
2006) ?