Forum Discussion
how to calculate age in excel
hii everyone, im learning excel from youtube tutorial which uses datedif to calculate age but im not getting that option in my excel. any help would be appreciable. thank you
Abhishek_Verma
This works best for me. In my sheet where column 'C' contains DOB.
=INT(YEARFRAC(C5, TODAY()))