Insert Date Field + 7

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cottage6 - 24 Mar 2005 15:09 GMT

Is there a way to insert the date field and then have it increment by 7 days
so it provides next week's date? I tried a few things but none of them
worked. I know I could get this from Excel as a merge field, but if there's
a way in Word I'd really like to know. Thanks!

Reply to this Message

Graham Mayor - 24 Mar 2005 17:41 GMT

This can be done with fields, but it is complicated - see
www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902
A macro might be simpler?

Sub DatePlus7()
Selection.InsertBefore Format((Date + 7), "d MMMM yyyy")
End Sub

(change the mask to suit local preferences)

Signature

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

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

> Is there a way to insert the date field and then have it increment by
> 7 days so it provides next week's date? I tried a few things but
> none of them worked. I know I could get this from Excel as a merge
> field, but if there's a way in Word I'd really like to know. Thanks!

Reply to this Message

Charles Kenyon - 24 Mar 2005 18:21 GMT

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.

Signature

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.

> Is there a way to insert the date field and then have it increment by 7
> days
> so it provides next week's date? I tried a few things but none of them
> worked. I know I could get this from Excel as a merge field, but if
> there's
> a way in Word I'd really like to know. Thanks!

Reply to this Message

cottage6 - 24 Mar 2005 19:39 GMT

Thank you both for your answers; it is definitely more complex than I
thought. The VB code worked nicely!

> 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
[quoted text clipped - 7 lines]
> > there's
> > a way in Word I'd really like to know. Thanks!

Reply to this Message