Forum Discussion
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...
Double "f" is for the function in VBA, here is
=DATEDIF(E3,G3,"Y")or
=YEARFRAC(G2,E2,1)depend on what exactly you'd like to calculate.
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?
Perhaps in your locale you shall use semicolons, not commas. Please check how it is in other formulas.
=DATEDIF(E3;G3;"Y")Thank you SergeiBaklan, that seems to work!
Anel0510 , you are welcome