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 ...

In this example, the date in cell "A1" will increment by one month. Add dollar signs to the cell reference to keep the reference from changing if you copy the formula.

There's more to EOMONTH() in Microsoft Excel than the last day of the month. Learn how to put it to use in your spreadsheets.

Create a custom date format based on one of Excel's standard date templates. For example, set all months to display as two digits by adding another "M" to the month format code.

If you need a monthly or yearly balance for revenue transactions in Microsoft Excel, you're in luck because both are easy! Here's how to find the totals you need.