How do I automatically insert the date one month from today?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Simon - 06 Mar 2007 06:39 GMT

I need to have the date one month from the current date automatically
inserted into a new document.

Reply to this Message

macropod - 06 Mar 2007 07:08 GMT

Hi Simon,

To see how to do this, check out my Date Calc 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902

No vba required.

Cheers

Signature

macropod
[MVP - Microsoft Word]
-------------------------

>I need to have the date one month from the current date automatically
> inserted into a new document.

Reply to this Message

Graham Mayor - 06 Mar 2007 07:09 GMT

http://www.gmayor.com/insert_a_date_other_than_today.htm

Signature

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

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

> I need to have the date one month from the current date automatically
> inserted into a new document.

Reply to this Message

Doug Robbins - Word MVP - 06 Mar 2007 07:13 GMT

Dim myrange As Range
myrange.Text = Format(DateAdd("M", 1, Date), "MMMM d, yyyy")

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I need to have the date one month from the current date automatically
> inserted into a new document.

Reply to this Message