How to Calculate Age in Ms Excel

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.

Next Post »