AnsweredAssumed Answered

Calculate date

Question asked by cmj on Aug 4, 2017
Latest reply on Aug 5, 2017 by fmpdude

I'm attempting to calculate the date of the last occurrence of a given week day (based on date1) that falls prior to date in the future.

For example: If date1 = August 15, 2017  - What is the date of the last week day (that's equal to the week day of August 15, 2017) prior to June 12, 2020 ?

The answer in this example is June 9, 2020. Simple to answer when looking at a calendar, but I just can't get my brain around calculating this.

Thanks

Outcomes