Excel formula to Find age in years months and days

Excel formula Find years months and days between two dates

Example: Put your date of birth in A1, Put the date you want to calculate age on a particular day in A2

Copy paste the following formula in any cell:

=DATEDIF(A1,b1,"Y")&" Years, "&DATEDIF(A1,B1,"YM")&" Months, "&DATEDIF(A1,B1,"MD")&" Days"