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

[Kaddy]

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?

 

[Frank Kabel]

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

 

[Ron Rosenfeld]

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

 

[Peo Sjoblom]

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)

 

[Gord Dibben]

Ron

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

Gord Dibben Excel MVP

 

[Ron Rosenfeld]

Ron

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

Gord Dibben Excel MVP

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

 

[Gord Dibben]

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

 

[Ron Rosenfeld]

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