Calculate Age in MS Excel

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

Syntax:

=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).

Example:

Look at the given below images:

Image 1:  

Image 2: