Forum Discussion

Anel0510's avatar
Anel0510
Copper Contributor
Aug 31, 2020

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...
Formulas and Functions
Anel0510's avatar
Anel0510
Copper Contributor
Aug 31, 2020

Hi Sergei, thanks for your reply! I have tried using both your suggested formulas (copy and pasted them), but I still get a message that there is an error (see attached file).

Any other suggestions?

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 31, 2020

Anel0510 

Perhaps in your locale you shall use semicolons, not commas. Please check how it is in other formulas.

=DATEDIF(E3;G3;"Y")

 

  • Anel0510's avatar
    Anel0510
    Copper Contributor
    Aug 31, 2020

    Thank you SergeiBaklan, that seems to work! 

Resources