Home

Automatic DATE today + X years

%3CLINGO-SUB%20id%3D%22lingo-sub-797250%22%20slang%3D%22en-US%22%3EAutomatic%20DATE%20today%20%2B%20X%20years%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797250%22%20slang%3D%22en-US%22%3EHi%2C%20I%20have%20been%20trying%20to%20find%20a%20way%2C%20how%20to%20generate%20automatic%20date%20today%20and%20add%20x%20amount%20of%20years%20to%20that.%20Example%3A%20I%20copy%20old%20MS%20word%20file%20in%20my%20pc%20and%20paste%20that%20file%20to%20update%20its%20content%20for%20a%20new%20event.%20In%20that%20new%20copy%2C%20I%20would%20like%20to%20see%20TODAY%C2%B4s%20DATE%2C%20that%20updates%20itself%2C%20lets%20say%20when%20I%20click%20save.%20And%20in%20another%20place%20inside%20the%20text%20I%20would%20like%20to%20see%20similar%20automatic%20date%20today%20%2B%2075%20years%20-%201%20day%20for%20example.%20so%2C%20I%20click%20save%20(or%20similar)%20and%20get%20text%20updates%20like%3A%20%22Mary%20went%20to%20London%20on%2005.05.2019%20and%20said%20next%20time%20she%20would%20go%20on%2004.05.2020%22%20So%20next%20time%20I%20use%20same%20file%20and%20update%20its%20macro%3F%20I%20get%20new%20date%20according%20to%20date%20on%20that%20day.%20Not%20sure%20how%20goes%20with%20355%20vs%20356%20days%20in%20one%20year%2C%20can%20excel%20calculate%20it%20on%20its%20own%20by%20calendar%3F%20Thanks%20for%20Tips%2C%20Joseph%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-798886%22%20slang%3D%22en-US%22%3ERe%3A%20Automatic%20DATE%20today%20%2B%20X%20years%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-798886%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F389774%22%20target%3D%22_blank%22%3E%40joosep90%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20sure%20which%20part%20you%20want%20to%20do%20in%20Word%20and%20which%20in%20Excel%20-%20you%20mention%20both.%3C%2FP%3E%3CP%3EYou%20can%20add%20today's%20date%20as%20a%20field%20in%20Word.%3C%2FP%3E%3CP%3EYou%20can%20add%20a%20year%20in%20Excel%20by%20adding%20365.25%20-%20that%20would%20be%207*365.25%20for%20seven%20years.%3C%2FP%3E%3CP%3EKind%20regards%3C%2FP%3E%3CP%3EHans%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-801760%22%20slang%3D%22en-US%22%3ERe%3A%20Automatic%20DATE%20today%20%2B%20X%20years%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-801760%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F389774%22%20target%3D%22_blank%22%3E%40joosep90%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20original%20document%20(or%20its%20template)%20contains%20a%20CREATEDATE%20field%20instead%20of%20just%20a%20DATE%20field%2C%20then%20opening%20the%20document%20and%20using%20the%20Save%20As%20command%20to%20create%20a%20copy%20of%20it%20(or%20creating%20a%20new%20document%20from%20the%20template)%20will%20automatically%20display%20the%20date%20when%20you%20did%20that.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20adding%20a%20constant%20amount%20of%20time%20to%20the%20date%2C%20see%20the%20Date%20Calculation%20Tutorial%20that%20you%20can%20download%20from%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.msofficeforums.com%2Fword%2F38719-microsoft-word-date-calculation-tutorial.html%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.msofficeforums.com%2Fword%2F38719-microsoft-word-date-calculation-tutorial.html%3C%2FA%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E
joosep90
Occasional Visitor
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 new event. In that new copy, I would like to see TODAY´s DATE, that updates itself, lets say when I click save. And in another place inside the text I would like to see similar automatic date today + 75 years - 1 day for example. so, I click save (or similar) and get text updates like: "Mary went to London on 05.05.2019 and said next time she would go on 04.05.2020" So next time I use same file and update its macro? I get new date according to date on that day. Not sure how goes with 355 vs 356 days in one year, can excel calculate it on its own by calendar? Thanks for Tips, Joseph
2 Replies

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

 

@joosep90 

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.

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies