Results 1 to 2 of 2

Thread: Week End date on Every Saturday

  1. #1

    Question Week End date on Every Saturday



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Conjurer Simi's Avatar
    Join Date
    Feb 2012
    Location
    Utah, USA
    Posts
    187
    Articles
    0
    This is marked as resolved on the thread posted above.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •