Adding Dates

Solved/Closed
Rachel - Oct 28, 2009 at 10:53 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Oct 30, 2009 at 01:56 AM
Hello,
I am trying to find a formula that calculates dates. Like I have two boxes with a beginning and date in them, and I want to calculate the days between. Example - Work dates 10/1/09 - 10/3/09 and I want a formula that calculates that it equals a total of 3 days. Can I do that?

1 response

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Oct 30, 2009 at 01:56 AM
Hello

If you have the dates in A1 & B1 and then in C1 put =B1-A1+1
Excel considers the date as a number
1