Display todays date + 10 working days

[GoodOne]

Hi,

I am creating a Word document where I want to display today's date plus 10
working days (ie Monday to Friday) automatically. I presume I need to
insert a field/formula. How can I do this or alternatively if that is not
possible, just todays date plus 14 days.

Thanks

 

[Vince]

MsgBox (Format(Now, "DD-MMM-YYYY")) ' Today's date
MsgBox (Format(DateAdd("d", 10, Format(Now, "DD-MMM-YYYY")), "DD-MMM-YYYY"))
' Today + 10 days

 

[Graham Mayor]

This is easy with vba, but with fields is rather complicated, but equally
possible - see
www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Helmut Weber]

Hi,
I hope you got some sense of humour.

I don't know where you're located,
but regional holidays may restrict your result to a region,
or even to members of a religious or so community.
If you want a perfect solution for a region, at least:
A workday may be defined as Monday to Friday, basically.
Then, I'd use Vince's example.
Then, define "days off", whereby a day off would be every
saturday and sunday, and each holiday, that isn't a saturday or
sunday anyway. With all that, check whether the last day
in the new calculated timespan is again a day off and add 1 day,
until the last day isn't a day off.
Can all be done.
I'm using Excel's workday definition for it plus
a list of additional days off. ;-)

Greetings from Bavaria, Germany

Helmut Weber, MVP
"red.sys" & chr(64) & "t-online.de"
Word XP, Win 98
http://word.mvps.org/

 

[Charles Kenyon]

This is more complex than you might imagine, but it can be done. See
http://addbalance.com/word/datefields2.htm for information on the different
kinds of ways to make a date calculation work. It includes links to pages
with fields and an explanation of different macros that can be used instead
of fields.

--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.