Calculate Next Tuesday

[Guest]

I need a function that will calculate what next Tuesday will be for any given
date.

I have an invoice that always arrives on Tuesdays, and I need to calculate
which Tuesday an item will be included in...

Thank you!

 

[George Nicholson]

NextTuesday = [MyDate] + (8 - Weekday([MyDate], vbTuesday))
or
NextTuesday = [MyDate] + (8 - Weekday([MyDate], 3))
(If MyDate is a Tuesday, formula returns the following Tuesday.)

NextTuesday = [MyDate] + (7 - Weekday([MyDate], vbWednesday))
or
NextTuesday = [MyDate] + (7 - Weekday([MyDate], 4))
(If MyDate is a Tuesday, formula returns MyDate, otherwise it returns the
following Tuesday.)

HTH,