On Fri, 10 Dec 2004 18:03:47 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

Ron

AFAIK Excel 2000 was the ONLY version to document the DATEDIF Function in
Help.

Gord Dibben Excel MVP

On Fri, 10 Dec 2004 20:46:02 -0500, Ron Rosenfeld
wrote:

On Fri, 10 Dec 2004 15:17:02 -0800, "Kaddy"
wrote:

I want to calculate the number of months between a fixed date and todays
date.
I don't see where Excel 2000 has a 'datedif' function. Does Excel 2003 have
this function?

Excel 2000 does have this function, although it may not be documented in HELP.

=DATEDIF(StartDate, EndDate, "m")

See http://www.cpearson.com/excel/datedif.htm for documentation.




--ron

Well, that's why I said "may not be documented" and did not say "is not
documented".

I knew there was one that had it, and I thought it was 2000. But when the OP
wondered if it was in 2000, I thought well maybe 2000 that doesn't have it
documented.

I've never run 2000, although I've used versions before and after.


--ron