Get Date of Next Named Day

[T-Square]

I am sure that this has been covered before, and I am sure it's a simple calculation, but I can't figure out how to find it or figure it.

I want to calculate the date of "Next Tuesday" (or Wednesday, etc.), regardless of what today is. So if today were 04/20/2009 (Monday), the date would be 04/21/2009 (Tuesday), but if today were 04/22/2009 (Wednesday), the date would be 04/28/2009.

TIA!

David

[comment]

Try:

today + Mod ( w - DayofWeek ( today ) - 1 ; 7 ) + 1

where w is a number between 1 and 7, signifying the day of week.