In this article you’ll learn, how to calculate years, month, and days elapsed from a certain date in Microsoft Excel.
To calculate year, months and days difference between two dates we can use DATEDIF function or we can use INT, MOD and TODAY functions.
Let’s take birthdate as an example,
Enter birthday date in cell A2: 8/7/1984
To calculate the number of years from the date, enter the following formula in cell B2: =YEAR(TODAY())-YEAR(A2)
The result (rounded): 31 Years
For a decimal solution, use the following formula: =DATEDIF(A2,TODAY(),”m”)/12
The result: 31.00 Years
To calculate the number of months from the date, enter the following formula in cell D2: =DATEDIF(A2,TODAY(),”m”)
The result: 372 Months
To calculate the number of days from the date, enter the following formula in cell E1:=DATEDIF(A1,TODAY(),”d”)
The result: 11333 Days
PS: A lot of site, avoid calculating date in Excel using DATEDIF function. The reason is “bugs”. DATEDIF function doesn’t have any documentation in Excel Help file.
But, Microsoft is continuously implying this feature / formula in all new version.
In case you wish to avoid DATEDIF function, you can use manual age calculation in Excel, like below:
=INT((TODAY()-A3)/365.25) & ” years , ” & INT(MOD((TODAY()-A4)/365.25,1)*12) & ” months and ” & INT(MOD((TODAY()-A4)/30.4375,1)*30.4375) & ” days”
It will give a day’s difference in Year Month and in days.
You can use A2 in case of today, where A2 is the greater day that A1 and gives you Elapsed time between these 2 dates.
This will work like an age calculator.
Note: – You can see the function has returned the number of years, month and days in between two dates. You can use this formula in 2007 and later versions of Microsoft Excel.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at firstname.lastname@example.org