DATEDIF(), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000, which is the only version that explains how this function works.

Office Q&A: How to stop Excel’s paste task from overwriting destination cell’s format Your email has been sent It's not easy to fool Excel, but with a few extra clicks, you can work around this odd ...