Skip to main content

Default date to the next Tuesday

I used this formula

=TODAY()+MOD(10-WEEKDAY(TODAY()),7) 

in a calculated field which seems to work. However, as TODAY is actually Tuesday, Sept 13, I need the date to reflect next Tuesday, Sept 20.

So, from Tue (Sep 13) to Mon (Sep 19), I need the date to default to Sep 20, and so on.

How do I adjust the formula to do that? Thanks!