All Collections
Advanced Document Automation
Formula Fields
Calculate Age Automatically based on Date of Birth
Calculate Age Automatically based on Date of Birth
E
Written by Eszter Takacs
Updated over a week ago

Say you collected the client's date of birth and you automatically want to calculate their age on your documents.

With Formula fields, you can easily do that:

1. Create the Date of Birth field

2. Create a Formula field and use INT and YEARFRAC formulas

INT(YEARFRAC({Date of Birth}, TODAY(), 1))

3: The formula field won't require user input and will automatically calculate the age:


Note: You can setup different formats for the date of birth if needed ( see below)





Find more Formula use cases below:

Did this answer your question?