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
You might find YEARFRAC to be more suitable. From what I read in this link DATEDIF is a function brought over from Lotus 1-2-3, so though it usually should work, it's not really an Excel function, whereas YEARFRAC is.
=INT(YEARFRAC(A1,B1)) will yield the age as an integer.