Forum Discussion
Anel0510
Aug 31, 2020Copper Contributor
Age formula not calculating
Good day, I am a beginner Excel user and am trying to calculate age between 2 different dates where B2 contains the date of diagnosis of a disease and E2 contains the date of birth. The column with m...
SergeiBaklan
Aug 31, 2020Diamond Contributor
Perhaps in your locale you shall use semicolons, not commas. Please check how it is in other formulas.
=DATEDIF(E3;G3;"Y")
Anel0510
Aug 31, 2020Copper Contributor
Thank you SergeiBaklan, that seems to work!
- SergeiBaklanAug 31, 2020Diamond Contributor
Anel0510 , you are welcome