Forum Discussion

joosep90's avatar
joosep90
Copper Contributor
Aug 09, 2019

Automatic DATE today + X years

Hi, I have been trying to find a way, how to generate automatic date today and add x amount of years to that. Example: I copy old MS word file in my pc and paste that file to update its content for a ...
hansleroy's avatar
hansleroy
Iron Contributor
Aug 11, 2019

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

 

Resources