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.

1] Add days directly If the expiry period is defined in days, you can calculate the expiry date by simply adding the number of days to the starting date using the + operator.

If you have to work with a date stamp in Microsoft Excel that includes date and time, you can use these simple expressions to extract both components, making them easier to work with.

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.