Want to know what date will be reached after a certain number of months have passed? Using Microsoft Excel’s EDATE function, you can add (or subtract) months to a specific date in your spreadsheets. Here’s how to use it.
Operation of the EDATE function
In Excel’s EDATE function, you specify the date (source date) to which you want to add months and the number of months to add. Excel then calculates the resulting date and displays it in the selected cell.
To subtract months from a date, enter a negative number of months. For example, to remove 3 months from a date, type -3 (minus three) instead of 3.
Microsoft Excel date and time functions
Adding months to a date in Excel
To begin the process of adding months, open your spreadsheet with Microsoft Excel.
In your spreadsheet, select the cell where you want to see the resulting date.
In the cell you selected, type the following function and press Enter. In this function, replace C2 with the cell containing your source date and C4 with the cell containing the number of months to add.
Enter the EDATE function.
In the selected cell, you will see the date that occurs after adding the specified number of months.
The result of the EDATE function.
If you see a string of numbers instead of the resulting date, it means your cell is not using the date format. To remedy this, in the Excel ribbon, at the top, click on the “Home” tab. Then, in the “Number” section, click on the drop-down menu and choose “Short date”.
Choose the “Short date” format.
There it’s done.
And that’s how you know what the date will be after adding a specific number of months to the source date. Very useful !
Did you know that you can also add days to your dates instead of months? Check out our guide to learn how to do it.