Auto Calculate Age in Excel

Less than a minute to read

hajarsabrani

6 August 2020

Calculate Automatic Age in Excel.
In excel, we can calculate birth dates automatically.
What we need is the date of birth data with the ‘date’ format, and the DATE IF formula.

How to do it?
Just check the formula below.
To see the formula, don’t forget to download the file first and open it with Microsoft Excel.

[google-drive-embed url=”https://drive.google.com/file/d/1EEvajC3mjswh73InCzJdlzd1NWkXzKBe/preview?usp=drivesdk” title=”Calculating Age from Date of Birth.xlsx” icon=”https://drive-thirdparty.googleusercontent.com/16/type/application/vnd.openxmlformats-officedocument.spreadsheetml.sheet” width=”100%” height=”400″ style=”embed”]