Please help me with formula to count : Sundays or Weeks per Month (Year 2006) ?
Please help me with formula to count : Sundays or Weeks per Month (Year 2006) ?
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 [email protected]> a écrit dans
le message de news: [email protected]...
> Please help me with formula to count : Sundays or Weeks per Month (Year
> 2006) ?
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 [email protected]> wrote in
message news:[email protected]...
> Please help me with formula to count : Sundays or Weeks per Month (Year
2006) ?
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 [email protected]> wrote in
message news:[email protected]...
> Please help me with formula to count : Sundays or Weeks per Month (Year
2006) ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks