View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Franz Verga Franz Verga is offline
external usenet poster
 
Posts: 459
Default How do/can I calculate the date for every Tuesday???

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