Assuming you have Month no. (1-12) in A2 thru A13,
=INT((DATE(2006,A2+1,0)-DATE(2006,A2,1)-(6-WEEKDAY(DATE(2006,A2,1),3)))/7)+1
and copy down
HTH
--
AP
"Sunday Function" <Sunday
a écrit dans
le message de news: ...
Please help me with formula to count : Sundays or Weeks per Month (Year
2006) ?