[Question] How to calculate difference between two days

[Hovey]

If I ahve a start date & end date, how I can get a correct difference
bewteen these two days?

For example, "Start Date" is 2006-05-29 and "End Date" is 2006-05-31. It
suppose is 2 days difference. I have used "Days360()" to calculate. The
result come out is "1".

How can I get a correct result?

 

[Dave Peterson]

Just subtract the two.

=a2-a1

Probably better, if you really want 1:
=a2-a1-1

Make sure the cell is formatted as General (or anything but Date).

 

[dodong]

Try this, supposed you want the difference between the date in cell A1
and B1

=DatedIF(A1,B1,"D")
this will give you the difference in Days, if you want the result by
month or year just replace D with M and Y for year.

Dodong

 

[Dave Peterson]

=datedif() seems a bit overkill to me when just subtracting would be sufficient.

To the OP:

Chip Pearson has some very nice notes at:
http://www.cpearson.com/excel/datedif.htm

If you want to look into that function.

 

[Hovey]

It's work!

Thank you very much!