April 23, 200916 yr 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
April 23, 200916 yr Try: today + Mod ( w - DayofWeek ( today ) - 1 ; 7 ) + 1 where w is a number between 1 and 7, signifying the day of week.
Create an account or sign in to comment