How to Calculate Age in Ms Excel with Datedif Function.Calculate age with datedif function
Calculate Year, Month, Day separately.
First year calculation:
Function =datedif(d8,today(),"Y")
d8 means insert date cell no.
"Y" means Year
Returns only Year.
Second Month calculation:
Function =datedif(d8,today(),"YM")
"YM" means Month return only month.
Finaly Day calculation:
Function =datedif(d8,today(),"D")
"D" means Days, return only month.