Hi everyone, 

I am writing a Business Plan and I’d like to insert a person’s age automatically as I don’t know when this document will be needed. Therefore I just want to make the document “smarter” by automating some things hence don’t worry about updating it in x years when it is needed. 

After a couple of hours of research now and endless attempts to do so I reached the end of my patience. The last thing I did was working with fields and inserting formulars I found online. 

Here is what I have written in a field (by pressing CTRL+F9): {=INT ({DATE@”yyyy”} + {DATE@”M”}/12 + {DATE@”d”}/365.25-1989-8/12-25/365.25)}

Here you can see that I want to calculate the age today of this person (DOB: 25 August 1989).

Any help here is greatly appreciated. Not sure if it is better to work with fields here or macros. Happy for every solution which is “easy” to implement 🙂

​Hi everyone, I am writing a Business Plan and I’d like to insert a person’s age automatically as I don’t know when this document will be needed. Therefore I just want to make the document “smarter” by automating some things hence don’t worry about updating it in x years when it is needed.  After a couple of hours of research now and endless attempts to do so I reached the end of my patience. The last thing I did was working with fields and inserting formulars I found online. Here is what I have written in a field (by pressing CTRL+F9): {=INT ({DATE@”yyyy”} + {DATE@”M”}/12 + {DATE@”d”}/365.25-1989-8/12-25/365.25)}Here you can see that I want to calculate the age today of this person (DOB: 25 August 1989). Any help here is greatly appreciated. Not sure if it is better to work with fields here or macros. Happy for every solution which is “easy” to implement 🙂  Read More

​