Excel Add Months to Date

This article outlines how to add months to a date in Excel.

How to make Excel Add Months to Date

In Excel, you can add a number of months to a date using the EDATE function.  This can be very useful when performing financial modeling and you are adjusting time periods.  This is a step by step guide to have Excel Add Months to Date.

For example, if you want to have a monthly financial model, you can add one month to the start date.  If you want a quarterly financial model, you can add 3 months to the start date.

Download the Free Excel Template – Add Months to Date


Formula for Excel add months to date

=EDATE(start date, number of months)

(See screenshots below)


Example of adding a month

Step 1: Ensure the starting date is properly formatted – go to Format Cells (press Ctrl + 1) and make sure the number is set to Date.

Step 2: Use the =EDATE(C3,C5) formula to add the number of specified months to the start date. Where cell C3 is equal to today’s date [the TODAY() function] and cell C5 is equal to the number 3.

Step 3: Make sure the output cell is formatted as a Date, and not as a general number (press Ctrl +1 and select Date)

Congratulations, you have now added months to a date in Excel!

Download the free template.

Excel Add Months to Date


add months to date in Excel