Calculate Age From ID Number In Excel Supposing you have a list of ID numbers which contain 13 digit numbers and the first 6 numbers is the birth date. Example 4- Calculating the Age in Excel in Year Months and Days. The simplest and most accurate formula to calculate age in Excel is DATEDIF birth_dateas_of_datey.
Other methods such as INT end-start36525 or INT YEARFRAC startend are not 100 correct.
The simplest and most accurate formula to calculate age in Excel is DATEDIF birth_dateas_of_datey. This mysterious function doesnt appear in Excels Help files but it has. The users of our Ultimate Suite dont have to bother about making their own age calculator in Excel - it is only a couple of clicks away. This uses the same basic formula as detailed above but with more.