I also get 165 as a result, and I think it's correct, I
have even counted the days between march 28 and october 10!
(if you want to include BOTH days in the calculation add 1
to the formula, i.e. from march 28 at 0:00 to october 28
However, if I use your data, the result I get is -165, I
am confused, how can the shiping date be prior to the
A very good formula for comparing dates is DATEDIF. It's
not included in the Excel help but Chip Pearson has a very
complete explanation for it at:
Just be sure to insert dates in it.