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]

Try this:

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

 

[satoshi_sd]

Try this:

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

Not working, the next date is 7 days instead of 4 days

 

[Legacy 143009]

Ok. I have tested this one:

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

 

[satoshi_sd]

Ok. I have tested this one:

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

I'm wondering, is there a possibility that your result and my result are showing different due to versions? I noticed that the number you changed is quite straightforward but my result as below

Current date	=TODAY()+5-WEEKDAY(TODAY()+7,1)
3/2/2023	2/2/2023
4/2/2023	2/2/2023
5/2/2023	9/2/2023
6/2/2023	9/2/2023
7/2/2023	9/2/2023
8/2/2023	9/2/2023
9/2/2023	9/2/2023
10/2/2023	9/2/2023
11/2/2023	9/2/2023
12/2/2023	16/2/2023
13/2/2023	16/2/2023

The result I'm expecting is

Current date	4-days interval
13/2/2023	16/2/2023 (1)
14/2/2023	16/2/2023 (2)
15/2/2023	16/2/2023 (3)
16/2/2023	16/2/2023 (4)
17/2/2023	20/2/2023 (1)
18/2/2023	20/2/2023 (2)
19/2/2023	20/2/2023 (3)
20/2/2023	20/2/2023 (4)
21/2/2023	24/2/2023 (1)

 

[Legacy 143009]

No, I am doing something wrong. Let me check again.

 

[Legacy 143009]

This will work only for the specified date sequence.

=TODAY()+3-MOD(TODAY()+2,4)

If you want something like this, then it must be a different formula:

Current date	4-days interval
14/2/2023	16/2/2023 (1)
15/2/2023	16/2/2023 (2)
16/2/2023	16/2/2023 (3)
17/2/2023	16/2/2023 (4)
18/2/2023	20/2/2023 (1)
19/2/2023	20/2/2023 (2)
20/2/2023	20/2/2023 (3)
21/2/2023	20/2/2023 (4)
22/2/2023	24/2/2023 (1)

 

[satoshi_sd]

This will work only for the specified date sequence.

=TODAY()+3-MOD(TODAY()+2,4)

If you want something like this, then it must be a different formula:

Current date	4-days interval
14/2/2023	16/2/2023 (1)
15/2/2023	16/2/2023 (2)
16/2/2023	16/2/2023 (3)
17/2/2023	16/2/2023 (4)
18/2/2023	20/2/2023 (1)
19/2/2023	20/2/2023 (2)
20/2/2023	20/2/2023 (3)
21/2/2023	20/2/2023 (4)
22/2/2023	24/2/2023 (1)

OMG IT"S WORKING NOW!! THANK YOU SO MUCH. I didnt know you can use MOD like that, that's new to me.

 

[Legacy 143009]

OMG IT"S WORKING NOW!! THANK YOU SO MUCH. I didnt know you can use MOD like that, that's new to me.

Yes, but as I told you, it depends on totally where you started first.

It will be a different story if you want something like this:

Current date	4-days interval
14/2/2023	17/2/2023 (1)
15/2/2023	17/2/2023 (2)
16/2/2023	17/2/2023 (3)
17/2/2023	17/2/2023 (4)
18/2/2023	21/2/2023 (1)
19/2/2023	21/2/2023 (2)
20/2/2023	21/2/2023 (3)
21/2/2023	21/2/2023 (4)
22/2/2023	25/2/2023 (1)

=TODAY()+3-MOD(TODAY()+2,4) : 3 stands for how many days forward you want to start your squence.
=TODAY()+3-MOD(TODAY()+2,4) : 2 is the number that you have to adjust according to your desired starting date.
=TODAY()+3-MOD(TODAY()+2,4) : 4 is the interval that you want to skip to the next date.