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
|