I found a site via Google that describes DateDif - it's been in Office for a
while but only ever 'exposed' via help or the formula editor in one version
so at least I get that piece.

The site also described how DateDif works. If I understand correctly, when
using the "md" option, it means 'take the difference in days between the two
dates entered and pretend they happen in the same month and year'.
(http://www.cpearson.com/excel/datedif.htm)

The difference between the 5th and 27th isn't 9 days but 22. So 9, 122, and
173 are all 'wrong'. I probably don't understand how DateDif works so
correct my assumptions if wrong.

I've been looking all over the web and an not finding any clear indicators
of whether SPs are part of builds or not. If I find the Rosetta stone, I'll
post back.

Dontcha love a good mystery?

Doug
"Peter T" wrote:

OK forget that idea then (fwiw the correct answer is 9, but DateDif is
buggy)