News

DATEDIF(), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000. It's fallen off current Excel menus, but you can still use it.
Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.
If Microsoft Excel does not recognize dates, then there is something wrong with the formatting. Use any of the methods mentioned here to format cells perfectly.