Auto Update Date Every 28 Days

[boylaban]

There's an old post Auto Update Date Every 7 Days

that uses =ceiling(today()+3,7)-3

I'm trying to automate the same but for Monday instead.

It looks like =ceiling(today()+3,7)-5 will show Mondays but how do I get it to update every 28 days instead of every week?

 

[I_know_nuffin]

TRY CEILING(TODAY()+3,28)-5

 

[I_know_nuffin]

TRY CEILING(TODAY()+3,28)-5

DOESNT WORK

 

[I_know_nuffin]

CEILING(TODAY()+28,7) -5