The only version of Excel to document DATEDIF was 2000.


Gord Dibben MS Excel MVP

On Mon, 2 Nov 2009 02:56:02 -0800, Roy Gudgeon
wrote:

Hi Jacob

about a minute after I posted the question I found a similar question with
an embedded link that pointed me to this formula and I got it too work.
My list of functions (EXcel2007) did not list this function but when I
wrote the syntax it still worked.

really appreciate you replying so promptly

thanks
Roy