How do/can I calculate the date for every Tuesday???
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
|