=TODAY()+CHOOSE(WEEKDAY(TODAY()),1),2,1,0,6,5,4,3)

and then just keep adding 7 for further dates.



--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jay" wrote in message
...
Hi guru's:

What I need is a method (formula) of calculting the date for Next Tuesday
and every Tuesday there after when the worksheet is opened? I need to look
at
the current system date and extract the next or up-coming Tuesday from
that
system date, even if it's the day (Monday) before the next Tuesday?

Looking forward to your input!

Thanks