How do I display a date in word merge documents that is 6 months in advance of the current (today's) date

I have a document in which I retrieve today's date using {MERGEFIELD "Todays Date"}. What I want to do is to display the date as six months in the future, i.e. 3/4/2014 displays as 3/10/2014 or 1/11/2014 displays as 1/5/2015 (Note: Australian date format, NOT US).

I also need the date to display as 3 October 2015 or 1 May 2015, i.e. dd/MMM/yyyy

Answer
Answer
To see how to do this and just about everything else you might want to do with dates in Word, check out my Microsoft Word Date Calculation Tutorial, at:
http://windowssecrets.com/forums/showthread.php/154368-Microsoft-Word-Date-Calculation-Tutorial
or:
http://www.gmayor.com/downloads.htm#Third_party
In particular, look at the items titled 'Calculate a day, date, month and year, using n months delay' and 'Date and Time Calculations In A Mailmerge'. Do read the document's introductory material.
Cheers
Paul Edstein
(Fmr MS MVP - Word)

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated October 5, 2021 Views 231 Applies to: