Weekend date

[imran ashraf]

[FONT=&quot]I want calculations that will automatically give me a given Monday's date on a rolling 8 week cadence. Once past a date the field would give the next Monday two months away's date. I've attached an ex. of what outputs would look like for diven dates. Self-contained is ideal, but can reference tables.
[/FONT][FONT=&quot]What I want is 8 weeks worth of Monday dates, but I only want the date to update as it is past. For example if the next Monday is the 12th, once it is the 13th,that cell updates to a Monday 8 weeks away (2/6) but no others change yet. Does that make sense?

[/FONT][TABLE="width: 528"]
<colgroup><col><col span="5"></colgroup><tbody>[TR]
[TD] [/TD]
[TD="colspan: 5"]Example date[/TD]
[/TR]
[TR]
[TD]Week[/TD]
[TD]12/7/2016[/TD]
[TD]12/13/2016[/TD]
[TD]12/27/2016[/TD]
[TD]1/31/2016[/TD]
[TD="align: right"]2/7/2016[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD="align: right"]12/12/2016[/TD]
[TD="align: right"]2/6/2017[/TD]
[TD="align: right"]2/6/2017[/TD]
[TD="align: right"]2/6/2017[/TD]
[TD="align: right"]4/3/2017[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD="align: right"]12/19/2016[/TD]
[TD="align: right"]12/19/2016[/TD]
[TD="align: right"]2/13/2017[/TD]
[TD="align: right"]2/13/2017[/TD]
[TD="align: right"]2/13/2017[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD="align: right"]12/26/2016[/TD]
[TD="align: right"]12/26/2016[/TD]
[TD="align: right"]2/20/2017[/TD]
[TD="align: right"]2/20/2017[/TD]
[TD="align: right"]2/20/2017[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD="align: right"]1/2/2017[/TD]
[TD="align: right"]1/2/2017[/TD]
[TD="align: right"]1/2/2017[/TD]
[TD="align: right"]2/27/2017[/TD]
[TD="align: right"]2/27/2017[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD="align: right"]1/9/2017[/TD]
[TD="align: right"]1/9/2017[/TD]
[TD="align: right"]1/9/2017[/TD]
[TD="align: right"]3/6/2017[/TD]
[TD="align: right"]3/6/2017[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD="align: right"]1/16/2017[/TD]
[TD="align: right"]1/16/2017[/TD]
[TD="align: right"]1/16/2017[/TD]
[TD="align: right"]3/13/2017[/TD]
[TD="align: right"]3/13/2017[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD="align: right"]1/23/2017[/TD]
[TD="align: right"]1/23/2017[/TD]
[TD="align: right"]1/23/2017[/TD]
[TD="align: right"]3/20/2017[/TD]
[TD="align: right"]3/20/2017[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD="align: right"]1/30/2017[/TD]
[TD="align: right"]1/30/2017[/TD]
[TD="align: right"]1/30/2017[/TD]
[TD="align: right"]3/27/2017[/TD]
[TD="align: right"]3/27/2017[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

This formula will return the next Monday (or today if today is a Monday):

=IF(WEEKDAY(TODAY(),2)=1,TODAY(),TODAY()+(7-WEEKDAY(TODAY(),3)))

So, to get the next 7 Mondays after that, simply add 7 to date, etc.

So, if you wanted these dates in cells A2:A9, you would simply enter that formula in A2, then the following:
In cell A3: =A2+7
In cell A4: =A3+7
etc.