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]

	Example date
Week	12/7/2016	12/13/2016	12/27/2016	1/31/2016	2/7/2016
1	12/12/2016	2/6/2017	2/6/2017	2/6/2017	4/3/2017
2	12/19/2016	12/19/2016	2/13/2017	2/13/2017	2/13/2017
3	12/26/2016	12/26/2016	2/20/2017	2/20/2017	2/20/2017
4	1/2/2017	1/2/2017	1/2/2017	2/27/2017	2/27/2017
5	1/9/2017	1/9/2017	1/9/2017	3/6/2017	3/6/2017
6	1/16/2017	1/16/2017	1/16/2017	3/13/2017	3/13/2017
7	1/23/2017	1/23/2017	1/23/2017	3/20/2017	3/20/2017
8	1/30/2017	1/30/2017	1/30/2017	3/27/2017	3/27/2017

<colgroup><col><col span="5"></colgroup><tbody>
</tbody>

 

[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.