Learn Excel 365 formulas fast! From AutoSum to Intellisense, learn how to work smarter and analyze data with ease. Tips, ...

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.

Subtracting isn’t as straightforward in Excel as it seems, simply because there’s no actual command to subtract numbers. Instead, you have to use a formula with the subtraction operator.