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.