If you have a date in A1, you can have a simpler formula
=4+(DAY(A1-DAY(A1)+35)<WEEKDAY(A1-DAY(A1)-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) ?