In this article we will learn about how to calculate years, month, days in between two dates in Microsoft Excel 2010.
In order to calculate the time passed from a certain date, we will use a birth date as an example
Enter birthday date in cell A1: 01/01/1980
To calculate the number of years from the date, enter the following formula in cell B1: =YEAR(TODAY())-YEAR(A1)
The result (rounded): 23 Years
For a decimal solution, use the following formula: =DATEDIF(A1,TODAY(),”m”)/12
The result: 23.25 Years
To calculate the number of months from the date, enter the following formula in cell D1: =DATEDIF(A1,TODAY(),”m”)
The result: 279 Months
To calculate the number of days from the date, enter the following formula in cell E1: =DATEDIF(A1,TODAY(),”d”)
The result: 8499 Days
PS: A lot of site, avoid to calculate date in Excel using DATEDIF function, due to some of bugs, as DATEDIF function dont have any documentation in Excel Help file,
But, Microsoft continuously giving this feature / formula in all new version.
In case if you also want to avoid DATEDIF function, you can use manual calculation.. like below…
=INT((TODAY()-A1)/365.25) & ” years , ” & INT(MOD((TODAY()-A1)/365.25,1)*12) & ” months and ” & INT(MOD((TODAY()-A1)/30.4375,1)*30.4375) & ” days”
it will give day 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..
You can see the function has return the number of years, month and days in between two dates. You can use this formula in 2007 and later versions of Microsoft Excel.