Calculate Next Tuesday

C

Cathy

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!
 
G

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,
 
Top