Does Excel 2000 have a 'datedif' function to calculate the number.
 

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?

Hi
it has (though n ot mentioned in the help file). See:
http://www.cpearson.com/excel/datedif.htm

--
Regards
Frank Kabel
Frankfurt, Germany

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?

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

I believe 2000 is the only version where it is documented

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Ron Rosenfeld" wrote in message
...
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

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

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

Ron

Not a criticism of your post.

Just info only for all readers, especially the OP who could not find a
reference to DATEDIF in 2000 Help.

Your "may not be documented" was noted by myself.

Gord

On Fri, 10 Dec 2004 21:42:13 -0500, Ron Rosenfeld
wrote:

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.

On Sat, 11 Dec 2004 10:05:12 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

Ron

Not a criticism of your post.

Just info only for all readers, especially the OP who could not find a
reference to DATEDIF in 2000 Help.

Your "may not be documented" was noted by myself.

Gord

No offense was taken. Just conversation. Sometimes tough to read nuances in
this medium, though.


--ron