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.

Reviews and recommendations are unbiased and products are independently selected. Postmedia may earn an affiliate commission from purchases made through links on this page. Learning to code in ...

How to Use TODAY() to Highlight Fast-Approaching Dates in an Excel Sheet Your email has been sent Use Microsoft Excel's TODAY() function in simple expressions to highlight the current date and past ...