Datedif Function???

[Guest]

One of my friends disclosed me the excellent function of
=Datedif(DateBeg,DateEnd,"D"/"M"/"Y")

Y such a function has been hidden?

R there any further similar xclent ones as well???

 

[JE McGimpsey]

Don't know that there's ever been any definitive reason given for hiding
the function. AFAIK, there are no more "hidden" XL functions.

You can find thorough documentation of DATEDIF here:

http://cpearson.com/excel/datedif.htm

Note that XL2000 Help *did* include an entry for DATEDIF (I don't know
about XL07).

Mac XL lists DATEDIF in Help.

 

[Stan Brown]

Mon, 28 May 2007 14:50:28 -0600 from JE McGimpsey

You can find thorough documentation of DATEDIF here:

http://cpearson.com/excel/datedif.htm

Cool! I never knew about that.

Just wondering -- Chip says "You can't use DATEDIF in VBA code."
Couldn't you do it with EVALUATE, though? I thought EVALUATE would
work with any worksheet function.

 

[JE McGimpsey]

Just wondering -- Chip says "You can't use DATEDIF in VBA code."
Couldn't you do it with EVALUATE, though? I thought EVALUATE would
work with any worksheet function.

Yes, you can use Evaluate...

Or you could use the somewhat different DateDiff VBA function