How to calculate the next Tuesday

L

Lee Perez

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

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.
 
R

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.
Click to expand...

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
 
J

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