Adding Dates

Solved/Closed
Rachel - 28 Oct 2009 à 10:53
Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 - 30 Oct 2009 à 01:56
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 11 April 2009 Status Member Last seen 21 June 2011 307
30 Oct 2009 à 01:56
Hello

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