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.


    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
    Utah, USA
    Excel Version
    Version 2002 Build 12527.20194
    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