How to Calculate Age (Days, Months or Years) in Excel
During this week we posted our first video from the Hack of the Week series where we showed you How to Calculate Age in Excel in Days, Months or Years. The trick shown in the video is a trick to combine Excel’s hidden function DATEDIF and IFERROR to create a new formula, ensuring a correct calculation of age in days, months or years without errors.
The DATEDIF function
Using the DATEDIF function on its own may result in a few errors and limitations, however our trick will allow you to use one single formula every time to calculate the correct age in days, months or years without errors.
Free Template and Video Tutorial showing How to Calculate Age in Excel
You can download now for free the Excel template with the formula demonstraded in the video below.
Other variations of the DATEDIF function
In addition to the example given in our video above, you can also try a few more variations of unit other than “Y“, “M” and “D” as detailed in Microsoft’s documentation and shown below:
DATEDIF(start_date,end_date,unit)
For instance, you can use =DATEDIF(“15-Jan-2019″,”1-Mar-2020″,”YM”) to calculate the number of complete months between 15 January and 1 March, which will result in 1 full month.
Hi, I’m Vini!
I’m an Engineer and Data Analyst, and I moved to Germany in 2018 to work for one of the biggest logistics companies in the world. Hacks for Data Analysis is the place where I consolidate and share my knowledge, feel free to reach out to me. Cheers!