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???

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 he

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.


In article ,
FARAZ QURESHI wrote:

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???

Mon, 28 May 2007 14:50:28 -0600 from JE McGimpsey
:
You can find thorough documentation of DATEDIF he

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.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

In article ,
Stan Brown wrote:

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