Display todays date + 10 working days

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
Wed May 25 22:06:26 CDT 2005


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



"GoodOne" <nospam@nospam.com.au> wrote in message
news:%23%239CIbZYFHA.796@TK2MSFTNGP10.phx.gbl...
> 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
>
>
>

Graham
Thu May 26 00:36:21 CDT 2005

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


GoodOne wrote:
> 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

Helmut
Thu May 26 03:02:52 CDT 2005

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
Thu May 26 14:19:24 CDT 2005

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.

"GoodOne" <nospam@nospam.com.au> wrote in message
news:%23%239CIbZYFHA.796@TK2MSFTNGP10.phx.gbl...
> 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
>
>
>