How to calculate the next Tuesday

[Lee Perez]

I have a date in Excel and I need it to look forward in time and find the
next closest Tuesday.

 

[albertmb]

I am no expert but I will try to help you. It would have helped me more if
you were a bit more specific. Like would you want the result in the same
cell or a different cell? if you want it in a differen cell you can use this
formula, insert the date of the first Teusday let's say in cell A1, in cell
B1 write this formula =A1+7. The following Teusday is always 7 days after
the first Teusday. Hope this answers you question.

 

[Ron Rosenfeld]

On Fri, 18 Sep 2009 08:59:01 -0700, Lee Perez <Lee

I have a date in Excel and I need it to look forward in time and find the
next closest Tuesday.

Do you want the NEXT Tuesday or the CLOSEST Tuesday.

The NEXT Tuesday:

=A1+8-WEEKDAY(A1+5)


The previous Tuesday:

=A1-WEEKDAY(A1-3)

So if you wanted the CLOSEST Tuesday you could construct an IF statement to
test the difference.
--ron

 

[Jim Thomlinson]

This function gives you the next Tuesday. If it is Tuesday it gives you the
next tuesday and not today...

=IF(WEEKDAY(Today())>2,Today()+8-WEEKDAY(Today())+2,Today()-WEEKDAY(Today())+3)