Tip 5: Date Arithmetic in Excel

10/20/2006; 3:31 AM

If you want to find the difference between two dates in Excel you can use a normal subtraction formula. Ex. =A1-A2.

This returns the difference in days but autoconverts it into a date. The converted date is incorrectly formatted so to get the number of days between the two dates change the cell format to general (type Ctrl+Shift+~).

If you want to get the number of years between the two dates divide by 365.25 and round up by 1 decimal place. Ex. =ROUND((A1-A2)/365.25,1).

Source: Excel Timesaving Techniques for dummies - Greg Harvey

This article is part of the Tip of the day project

Logon

Fill out the form below to logon to this site, or sign up below.

Username (email address):
Password:
I forgot my password; please send me a new one.
 

Signup

Fill out the form below to join as a member of this site.

Screen name:
Email address:
Password:
Repeat password:
Homepage (optional)