Aug 09 2019 04:36 AM
Aug 11 2019 02:26 AM
Hi @joosep90
Not sure which part you want to do in Word and which in Excel - you mention both.
You can add today's date as a field in Word.
You can add a year in Excel by adding 365.25 - that would be 7*365.25 for seven years.
Kind regards
Hans
Aug 12 2019 07:55 PM
If the original document (or its template) contains a CREATEDATE field instead of just a DATE field, then opening the document and using the Save As command to create a copy of it (or creating a new document from the template) will automatically display the date when you did that.
For adding a constant amount of time to the date, see the Date Calculation Tutorial that you can download from https://www.msofficeforums.com/word/38719-microsoft-word-date-calculation-tutorial.html.