I need to have the date one month from the current date automatically inserted into a new document.
S Simon Mar 6, 2007 #1 I need to have the date one month from the current date automatically inserted into a new document.
M macropod Mar 6, 2007 #2 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
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
G Graham Mayor Mar 6, 2007 #3 http://www.gmayor.com/insert_a_date_other_than_today.htm -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
http://www.gmayor.com/insert_a_date_other_than_today.htm -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
D Doug Robbins - Word MVP Mar 6, 2007 #4 Dim myrange As Range myrange.Text = Format(DateAdd("M", 1, Date), "MMMM d, yyyy") -- 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
Dim myrange As Range myrange.Text = Format(DateAdd("M", 1, Date), "MMMM d, yyyy") -- 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
