Calculate difference between two dates

T

Trainer

I have a spreadsheet with two date columns, a start date and an end date, eg
14/02/05 and 19/02/05. This is actually 6 days, but if I subtract one from
the other I get 5. Any ideas, please.
 
J

JulieD

Hi

the "problem" is that dates are just numbers in disguise and if you have the
formula
19-14
you'll end up with the answer of 5
so if you want the maths in excel to behave differently (ie you definition
is different from excel's) you'll need to incorporate that in the formula
e.g.
=19-14+1

Cheers
JulieD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem formatting dates from CSV file 2
Returning a Date with Multiple Criteria Lookup Values 0
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Calculate elapsed time excluding specific timeframe 10
Average days between dates 3
Sum value between two dates and copy to new cell 7
IF ARRAY with multiple conditions. 1
Modifying a complex date formual to count months 4

Top