Conversion of date format dd/mm/yy to age in Microsoft Excel?

Question

My question is to calculate the age of a person directly from two date formats given in dd/mm/yy working in Microsoft Excel.

Answer 1

Or
Just like that
Start Date in A1, End Date in B1
In B2 paste this
=( B1-A1) / 365.4

Select B2, go to Format > Cells > Number > Number > Ok

This will give you the exact number of years from start date to end date

Enjoy my profile, I am the VBAXLMan

Answer 2

A is column

A
Date
6/9/2007
6/4/2010
Formula Description (Result)
=YEAR(A3)-YEAR(A2) Years occurring between two dates (3)


Notes

To view the dates as numbers, select the cell and click Cells on the Format menu. Click the Number tab, and then click Number in the Category box.
You cannot subtract a date that is later than another date, or the error #### appears in the cell.