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.

The EOMONTH function in Microsoft Excel returns the last day of a month in the past, the current month, or a month in the ...

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.

SUM is the spreadsheet equivalent of an open invite: it welcomes everything into the total, whether it belongs there or not.

Excel's data validation feature is more versatile than you might think. Learn how to use literal values, input values, list values, and even formulas to restrict input date values using data ...

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

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.