Datedif function

[shaji]

I am using excel2003 and installed analysis toolpack in the addin also. But
when I am looking for DATEDIF function, the same is not showing. can any one
help me to install the DATEDIF function in the excel

shaji

 

[Dave Peterson]

It's not part of the analysis toolpak--it's built directly into excel.

But except for xl2k, it's never been documented in excel's help.

Chip Pearson has some very nice notes at:
http://www.cpearson.com/excel/datedif.htm

 

[David Biddulph]

I am using excel2003 and installed analysis toolpack in the addin also. But
when I am looking for DATEDIF function, the same is not showing. can any
one
help me to install the DATEDIF function in the excel

The function is there, it's just missing from the help facility.
http://www.cpearson.com/excel/datedif.htm