AnsweredAssumed Answered

How to calculate last day of the week?

Question asked by jakes on Feb 9, 2015
Latest reply on Feb 9, 2015 by philmodjunk

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

Outcomes