Tech Support Guy banner
  • Please post in our Community Feedback thread for help with the new forum software! If you are having trouble logging in, please Contact Us for assistance.
Status
Not open for further replies.
1 - 3 of 3 Posts

·
Registered
Joined
·
146 Posts
Discussion Starter · #1 ·
Is there a way to do this in Excel:

Column 1 = date
Column 2= another date
column 3 = difference between the dates in days

I.E.

Column 1= 02/01/2008
Column 2= 02/28/2008
Column 3= 28
 

·
Registered
Joined
·
19,896 Posts
The actual difference is 27 between the days, so this works
=b1-a1
but you have to format the the c1 cell as a number
If you wanted it to be 28 then you would need to use
=(b1-a1)+1
 

·
Registered
Joined
·
7,837 Posts
Just FYI, Excel actually calculates dates as the number of days since 1/1/1900 (well, 1900 sometime, I think) - if you change the formatting on a date to General, you will see that 02/01/2008 is actually dealt with as 39479, and 02/28/2008 is 39506. Ignoring the 39s, subtract 479 from 506 gives you the number of days that separate the two dates, that is 506-479=27
 
1 - 3 of 3 Posts
Status
Not open for further replies.
Top