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

Hi Jay,

try this

=if(weekday(a1)=1,(a1+2),if(weekday(a1)=2,(a1+1),i f(weekday(a1)=3,(a1+7),if(weekday(a1)=4,(a1+6),if( weekday(a1)=5,(a1+5),if(weekday(a1)=6,(a1+4),if(we ekday(a1)=7,(a1+3))))))))

hth
regards from Brazil
Marcelo



"Jay" escreveu:

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

=TODAY()+10-WEEKDAY(TODAY())
macro
MsgBox Date + (10 - Weekday(Date))

--
Don Guillett
SalesAid Software

"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

Jay wrote:
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

Hi Jay,

try this:

=TODAY()+9-WEEKDAY(TODAY(),2)


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

If you're only interested in the date and not the time value that goes along
with it, try this ...

=TEXT(NOW(), "dd-mmm")+8-(WEEKDAY(NOW()))

HTH.

"Jay" wrote:

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

Sorry it should have been...

=TEXT(NOW(), "dd-mmm")+10-(WEEKDAY(NOW()))



"DaveO" wrote:

If you're only interested in the date and not the time value that goes along
with it, try this ...

=TEXT(NOW(), "dd-mmm")+8-(WEEKDAY(NOW()))

HTH.

"Jay" wrote:

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

=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