## Create an Excel Formula that Calculates Time Between 2 Dates

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.

This entry was posted in Excel. Bookmark the permalink.

### 4 Responses to Create an Excel Formula that Calculates Time Between 2 Dates

1. lbrooks687 says:

is there away to make a excel spreadsheet that to show dates for commercial drivers physical that would be due every 2 years and some 1 year, and when the drivers license would be due; and alert or color change? I track 42 commercial drivers and I must notifie them at least 2 to 3 weeks prior to the due dates.

• Steve Chase says:

There is not an alert option that I know of unless you customize some code using VBA. You can create a formula using conditional formatting that could change color when a date you want to track changes. For example you would need to use the TODAY() function. I have written a couple posts that might give you some ideas. if you search conditional formatting in the side bar please.

• Steve Chase says:
2. Gabrielle Aggas says:

This website is just gret. I’ve researched these details a whole lot and I view it that is professional, fast
to comprehend. I congratulate you because of this research that I’ll recommend to prospects around.
I request you to visit the gpa-calculator.co page where each scholar or scholar
can calculate results grade point average marks.
Success!