Posted on: Week End date on Every Saturday
I want to generate Week End Date according to ISO Standards for all 52/53 weeks.
My week end's on Saturday
I tried this two formulas.
=DATE(B1,1,1)+7-WEEKDAY(DATE(B1,1,1))
&
=DATE(P2,1,1+((1-(5>=WEEKDAY(DATE(P2,1,1))))*7)+(5-WEEKDAY(DATE(P2,1,1))))+2
Where B2 is passing Year only.
But it is not handling Year with 53 weeks.
I want formula which will generate 52 or 53 week according to year.
(Should generate 52 only where there in 52 week and 53 where there is 53 Weeks)
Please Help. Thanks in Advance
I want to generate Week End Date according to ISO Standards for all 52/53 weeks.
My week end's on Saturday
I tried this two formulas.
=DATE(B1,1,1)+7-WEEKDAY(DATE(B1,1,1))
&
=DATE(P2,1,1+((1-(5>=WEEKDAY(DATE(P2,1,1))))*7)+(5-WEEKDAY(DATE(P2,1,1))))+2
Where B2 is passing Year only.
But it is not handling Year with 53 weeks.
I want formula which will generate 52 or 53 week according to year.
(Should generate 52 only where there in 52 week and 53 where there is 53 Weeks)
Please Help. Thanks in Advance
Last edited:
