S
Sunday Function
Please help me with formula to count : Sundays or Weeks per Month (Year 2006) ?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Ardus Petus
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
=INT((DATE(2006,A2+1,0)-DATE(2006,A2,1)-(6-WEEKDAY(DATE(2006,A2,1),3)))/7)+1
and copy down
HTH
B
Bob Phillips
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)
=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)
2006) ?Sunday Function said:Please help me with formula to count : Sundays or Weeks per Month (Year
B
Bob Phillips
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)
=4+(DAY(A1-DAY(A1)+35)<WEEKDAY(A1-DAY(A1)-1))
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
2006) ?Sunday Function said:Please help me with formula to count : Sundays or Weeks per Month (Year