Forum Discussion
Jan Joosten
Nov 01, 2018Copper Contributor
Calculate age
How do I calculate age with DATEDIF. In exel works do that with a date such as d-mm/dd/yyyy format. In the examples I see the d/mm/yyyy date format how do I change it Hoe kan ik een leeftijd bere...
Nov 01, 2018
For getting the age, I would recommend YEARFRAC.
How to and examples here:
https://support.office.com/en-us/article/yearfrac-function-3844141e-c76d-4143-82b6-208454ddc6a8
How to and examples here:
https://support.office.com/en-us/article/yearfrac-function-3844141e-c76d-4143-82b6-208454ddc6a8