This post will show you how to create a formula that calculates times between 2 dates. The pattern for dates in Excel are as follows:
- Jan 1, 1900 = 1
- Jan 2, 1900 = 2
- Jan 3, 1900 = 3
- Nov 11, 2013 = 41,589
So understanding that Excel has a number assigned for a date, you can subtract 2 dates to calculate the difference. Once you subtract the past from the future date, divide by 365 to break it down by years.
There is a function =TODAY() that updates to the current date when the file is refreshed or opened. The formula =(TODAY()-B2)/365.25. You noticed the 365.25.🙂 That .25 is for you nerds out there that want to take leap year into the formula.
Once you get the values, format the cells with fewer decimals.
Download my Excel keyboard shortcuts here.