• Share

Discuss in my forum

# Calculate a Due Date in Excel

## Calculate a Due Date with the EOMONTH Function

Calculate a Due Date in Excel

The EOMONTH function, short for End of Month function can be used to calculate a due date of a project or investment that falls at the end of the month.

The syntax for the EOMONTH function is:

= EOMONTH ( Start_date , Months )

Start_date - the start date of the project or time period in question.

Months- the number of months before or after the Start_date.

### Calculating a Due Date with the EOMONTH Function

For help with this example, see the image above.

1. Enter the following data into the appropriate cell:

D1 - Start Date:
D2 - Months:
D2 - Due Date:
E1 - 7/6/2009
E2 - 7

Note: If the date in cell E1 does not appear correct, check to see that the cell is formatted for dates.

2. Click on cell E3 - the location where the results will be displayed.

3. Click on the Formulas tab.

4. Choose Date and Time functions > EOMONTH from the ribbon to bring up the function's dialog box.

5. Click on the Start_date line in the dialog box.

6. Click on cell E1 in the spreadsheet to enter that cell reference into the dialog box as the Start_date argument.

7. Click on the Months line in the dialog box.

8. Click on cell E2 in the spreadsheet to enter that cell reference into the dialog box as the Months argument.

9. Click OK in the dialog box.

10. The end date - 2/28/2010 appears in cell E3 which is the end of the seventh month after the start date.

11. When you click on cell E3 the complete function = EOMONTH ( E1 , E2 ) appears in the formula bar above the worksheet.

Note: The EOMONTH function can also be used to find a date in the past - such as the day work began on a project. To do so enter a negative number for the Months argument and use the project's end date for the start_date argument.

Ted French