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