Previous Topic Next Topic

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

Answer 1 / 1
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

Similar discussions

encryption message several time in chat
measking -
HelpiOS -

1 response
Ig stories from close friends to public
Darren -
zara -

31 responses
IF statements with dates and criteria
jimbabama -
Mazzaropi -

3 responses
blank white page for website
yadaves -
ac3mark -

1 response
using web browser page loads but screen blank
inchoate -
leo -

16 responses