Autoupdate date

[gigi11]

I have a sheet for managing schedules for a team and we have a checklist to see who has updated it for the following week.
Cell C4 states the week starting date (every Monday). I want this to update each Sunday to state the following Monday date and to remain as this for the entire week.

I used the function:
=TODAY()+(7-WEEKDAY(TODAY(),3))
However, as soon as it turns Monday it updates to the following Monday so it is a week ahead. I'm unsure how to rectify this so it stays as the current week.

 

[kevin9999]

Until a more elegant solution comes along, try the following:

=IF(WEEKDAY(TODAY())=1,TODAY()+4-WEEKDAY(TODAY(),15),TODAY()-WEEKDAY(TODAY(),3))

 

[Micron]

this should also work but you would have to alter your date in regional settings to know ahead of time. Worked for me
=TODAY()-WEEKDAY(TODAY(),3)

 

[kevin9999]

this should also work

But if you replace Today() with next Sunday's date (10th March) does it return Monday 11th March?