Thread: Sunday Function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
 
Posts: n/a
Default Sunday Function

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) ?