|I think this will work for you without VBA. You can change your system's date to test it. You'll need to force a calculation after you change the date to get it to update.|
Somewhere in your workbook put a list of all the Monday dates. I'll use G1:G6 as an example. You can hide this column if you want.
Then use these formulas to fill in your dates, which should update automatically each week:
A B C
1 MONDAY TUESDAY WEDNESDAY
2 =VLOOKUP(TODAY(),G2:G10,1,1) =A2+1 =B2+1
Note that the VLOOKUP uses the approximate match argument of "1" (TRUE) to return "the largest value that is less than or equal to lookup_value" TODAY() which means that it will always return the current week's Monday date".
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.