How can I add or subtract months from a date using the EDATE function in Excel? To use the EDATE function you will need the starting date and the number of months to add or subtract.

Learn how to highlight dates before today and a specific date with and without using the Today() function in Microsoft Excel.

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.

However, many people brand new to Excel don’t realize how much easier the power of Excel’s formulas can make your job of keeping information current and accurate. A formula ...