Calculate Next Tuesday

  • Thread starter Thread starter Guest
  • Start date Start date
G

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