Brian from Maui
MrExcel MVP
- Joined
- Feb 16, 2002
- Messages
- 8,459
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!..... 
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
DATEDIF
- Thread starter Brian from Maui
- Start date
Excel Facts
Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
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!
http://www.cpearson.com/excel/datedif.htm
Bizarre!
Upvote
0
Brian from Maui
MrExcel MVP
- Joined
- Feb 16, 2002
- Messages
- 8,459
dk said:
Dan,
Thank-you for my sanity. It is BIZARRE!
Upvote
0
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
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
Upvote
0
