Forum Discussion
Automatic Age Calculation in Word Document
Accurately knowing your age is easy with modern online tools. By entering your date of birth, you can instantly calculate your age in years, months, days, or even minutes—saving time and ensuring precision for personal or professional needs. You can use a https://agecalculatorsa.com tool to quickly verify your Word field output.
The field approach Charles_Kenyon shared is the most robust for a Word document that needs to stay self-contained. The {ASK} field combined with the {SET} calculations is clever because it doesn't rely on external data sources.
One important caveat with the field method: it recalculates every time the document is opened or printed, which is exactly what you want for a "smart" document. However, if you're sharing the document with others, the {ASK} prompt will appear for them too, which may not be ideal.
The VBA macro that cdrgreg posted is more powerful for complex scenarios, especially if you need the age in years, months, and days format. But for a simple business plan where you just need the age in years, the field approach is probably sufficient.
I'd recommend testing both methods with a few edge cases—like February 29th birthdays and dates near the end of the month—to see which one handles them correctly for your needs.