5 Replies Latest reply on Feb 9, 2015 10:49 AM by philmodjunk

    How to calculate last day of the week?

    jakes

      Title

      How to calculate last day of the week?

      Post

      I need a formula to calculate the last day of the week which is a saturday.

      I want to enter a date and it must give me the last date of the week in a date format. If the date I enter is a saturday it must give me that date as it's the last date of the week.

      For example.

      If I enter todays date "2015/02/09" The result must be "2015/02/14"

      If I enter "2015/02/14" The result must be "2015/02/14"

      If I enter "2015/02/05". The result must be "2015/02/07"

      Thank you