Setting reminder in excel with no end date

[satoshi_sd]

Hi,

I need help to set a reminder in excel (preferably a formula) and to recur every week interval. Example, the date now is showing due date on 12/2/2023 and after 12/2/2023, it will automatically change to 19/2/2023 (in which I don't need to update anything and it will keep running).

The idea in my mind is something to do =today() but I can't squeeze anything out from my brain

 

[Legacy 143009]

Like this?

=TODAY()-WEEKDAY(TODAY(),1)+1

 

[satoshi_sd]

@Flashbond not exactly, the return is showing me 5/2/2023 (back-date). I want it be 12/2/2023 (weekahead).
Also, I would like to add another reminder with 2 weeks interval too.
Thanks, sorry for being so demanding

 

[Legacy 143009]

This is not a reminder. This date will update itself only once a week. When you enter a new week, it will show the date one week ahead and won't change until the other week.

=TODAY()+8-WEEKDAY(TODAY()+7,1)

For two weeks:
=TODAY()+15-WEEKDAY(TODAY()+14,1)

 

[satoshi_sd]

Thanks!!!!!! It works perfectly!!!

 

[Legacy 143009]

Ok thanks for the feedback

 

[satoshi_sd]

@Flashbond Hi, do you have a way to make it every 4 days interval?

Btw, future reference for this community, I have enhanced the formula for every 2 weeks interval
=IF(MOD(WEEKNUM(TODAY()),2)=1,TODAY()+8-WEEKDAY(TODAY()+14,1)-1,TODAY()+15-WEEKDAY(TODAY()+14,1)-1)

 

[satoshi_sd]

bump

 

[Legacy 143009]

What do you mean by 4 days interval?
=TODAY()+4??

 

[satoshi_sd]

not exactly, it will show 16/2 today, and tommorrow 17/2 if I open the excel. I want it to stay 16/2 when I open the excel on 12/2 to 16/2 everyday. Then on 17/2 to 20/2 everyday, it will show 20/2.

Example

Current date	Cell will show these date
13/2/2023	16/2/2023
14/2/2023	16/2/2023
15/2/2023	16/2/2023
16/2/2023	16/2/2023
17/2/2023	20/2/2023
18/2/2023	20/2/2023
19/2/2023	20/2/2023
20/2/2023	20/2/2023
21/2/2023	24/2/2023