The DATEDIF Function
Category: General Weirdness | [Item URL]
The DATEDIF function calculates the difference between two dates, and expresses the result in terms of months, days, or years.
If you have Excel version 5.0 or later, you can make use of the handy DATEDIF function in your formulas. But if you want to read about this function in the Help, you must have Excel 2000. For some reason, the function was never documented until Excel 2000. And the documentation was removed from versions that followed.
The DATEDIF function has its origins in Lotus 1-2-3. Apparently, Microsoft included it in Excel for compatibility purposes. Why is it not documented? Who knows? But it's likely that lawyers are involved.
Chip Pearson has some good information about DATEDIF at his
web site.
Excel Oddities
Excel is a complex program, and has been around for a long time. Consequently, it has many obscure nooks and crannies to discover. Some of them are described here.
Keep in mind that some versions of Excel are odder than others. In other words, the things described here may not apply to all versions of Excel.
All Odd Stuff
Browse Oddities by Category
Seen Something Odd?
If you've discovered something weird about Excel, let me know.