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

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.

"Lee Perez" wrote:

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

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

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

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)
--
HTH...

Jim Thomlinson


"Lee Perez" wrote:

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

=A1+MOD(10-WEEKDAY(A1),7)
--
David Biddulph

"Lee Perez" <Lee wrote in message
...
I have a date in Excel and I need it to look forward in time and find the
next closest Tuesday.

To calculate the next Tuesday from a given date in Excel, use the following formula:

Here, A1 is the cell containing the date you want to start from.

How this formula works:

1. The WEEKDAY function returns a number representing the day of the week (1 for Sunday, 2 for Monday, and so on).
2. If the given date is on or before Tuesday (i.e., if WEEKDAY(A1) is 1, 2, or 3), then we add 3 minus the weekday number to the date to get the next Tuesday. For example, if the given date is a Monday (weekday number 2), we add 3-2=1 day to get to Tuesday. If the given date is a Sunday (weekday number 1), we add 3-1=2 days to get to Tuesday.
3. If the given date is after Tuesday (i.e., if WEEKDAY(A1) is 4, 5, 6, or 7), then we add 10 minus the weekday number to the date to get the next Tuesday. For example, if the given date is a Wednesday (weekday number 4), we add 10-4=6 days to get to the next Tuesday. If the given date is a Saturday (weekday number 7), we add 10-7=3 days to get to the next Tuesday.

Once you enter this formula in a cell, it will return the next Tuesday from the given date. You can then copy and paste the formula to other cells as needed.