Calculate Age in MS Excel

Microsoft Excel is a sea of tricks. You can calculate age using DATEDIF function. Look at syntax and example:


=DATEDIF (“Start Date”,” End Date”, “Interval”)

Where Interval can be Y (years), M (month), D (days), YM (year month), MD (month days), YD (year days).

Note: Date format accept only (Month-Date-Year) or (15-may-1986).


Look at the given below images:

Image 1:  

DATEDIF function in Excel

Image 2:

Calculate Age in MS Excel