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.
Use Microsoft Excel’s TODAY() function in simple expressions to highlight the current date and past and future dates. We may earn from vendors via affiliate links or sponsorships. This might affect ...