DATEDIF

[Brian from Maui]

Anyone with XP or 2003, is DATEDIF in your Help files? I can't find any documentation of DATEDIF in either XP or 2003. Or am I going BONKERS!.....

 

[dk]

No Brian, you're not going bonkers. Chip mentions here that it's only documented in Excel 2000:

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

Bizarre!

 

[Brian from Maui]

No Brian, you're not going bonkers. Chip mentions here that it's only documented in Excel 2000:

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

Bizarre!

Dan,

Thank-you for my sanity. It is BIZARRE!

 

[Ekim]

Even more bizarre, the VBA help file (Excel XP) provides information on the VBA DATEDIFF function (note the double “F”), which is different from the worksheet function DATEDIF. The functionality of the VBA function is more or less the same as the worksheet function, but the setup is different. Also, DATEDIF is not a method of Application.WorksheetFunctions.

Some stuff here on DATEDIFF (VBA)
http://j-walk.com/ss/excel/tips/tip55.htm

Fairly good reference material by Norman Harker on the DATADIF worksheet function:
http://makeashorterlink.com/?R3CB254A7

Regards,

Mike