Return to Question

I used this formula =TODAY()+MOD(10-WEEKDAY(TODAY()),7) in a calculated ate 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!

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!

I used this formula =TODAY()+MOD(10-WEEKDAY(TODAY()),7) 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!

I used this formula =TODAY()+MOD(10-WEEKDAY(TODAY()),7) in a calculated ate 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!