Thread
:
How do/can I calculate the date for every Tuesday???
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
How do/can I calculate the date for every Tuesday???
=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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett