Thread: Sunday Function
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default Sunday Function

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