Hi To Calculate the date, we can use Excel's DATEDIF function to calculate a person's current age. If you don't feel like dragging out a calendar, a simple spreadsheet formula can come to the rescue.
Alternatively, use the function to compute the difference between any two dates.
The DATEDIF function determines a person's current age in years, months, and days in the following formula.
=DATEDIF(E1,TODAY(),"Y")&" Years, "&DATEDIF(E1,TODAY(),"YM")&" Months, "&DATEDIF(E1,TODAY),"MD")&" Days"