# EDATE

The `EDATE` function in Google Sheets returns a date that is a specified number of months before or after a specified date. It is most commonly used to calculate due dates for invoices, project deadlines, or loan repayments.

## Usage

Use the `EDATE` formula with the syntax shown below, it has 2 required parameters:

Parameters:
1. start_date (required):
The starting date from which to calculate the result. Must be a valid date or a reference to a cell containing a date.
2. months (required):
The number of months to add or subtract from the starting date. Must be a positive or negative integer or a reference to a cell containing such a value.

## Examples

Here are a few example use cases that explain how to use the `EDATE` formula in Google Sheets.

### Calculate due dates for invoices

By using the `EDATE` function with a reference to a cell containing the invoice date and a fixed number of months for payment terms, you can easily calculate the due date for the invoice.

When planning a project, you can use the `EDATE` function to calculate deadlines based on the start date and the duration of each task in months.

### Calculate loan repayments

To calculate the monthly repayment amount for a loan, you can use the `EDATE` function to add the number of months in the loan term to the start date, and then use other functions to calculate the interest rate and principal amount.

## Common Mistakes

`EDATE` not working? Here are some common mistakes people make when using the `EDATE` Google Sheets Formula:

### Incorrect date format

Ensure that the start_date input is in a valid date format, use the DATE function if necessary.

### Incorrect month value

Ensure that the months input is a valid number between -32767 and 32767.

### Using wrong arguments

Ensure that the start_date and months arguments are in the correct order and separated by a comma.

The following functions are similar to `EDATE` or are often used with it in a formula:

• `TODAY`

The `TODAY` function returns the current date in the default timezone of the spreadsheet. The date is updated each time the spreadsheet is opened. This function is commonly used to calculate the current age or to track the number of days since a certain event, among other things.

• `DATEDIF`

The `DATEDIF` function in Google Sheets calculates the difference between two dates using a specified unit of measurement. This function is commonly used to calculate the length of time between two dates, such as the number of days, months, or years. The function is particularly useful when working with financial or project planning data.

• `EOMONTH`

The `EOMONTH` function returns the date of the last day of the month that is the indicated number of months before or after the start date. This function is commonly used to calculate due dates, expiration dates, and other dates relative to a specified start date.

• `WORKDAY`

The `WORKDAY` function returns a date that is a specified number of workdays (excluding weekends and holidays) away from a given start date. This function is useful for calculating a project deadline or delivery date. The function takes the start date and the number of workdays to add to the start date. Additionally, you can specify a range of holiday dates to exclude from the calculation.

• `NETWORKDAYS`

The `NETWORKDAYS` function returns the number of working days between two given dates. This function excludes weekends (Saturday and Sunday) and optionally, any specified holidays. This function is commonly used in financial and business applications to calculate the number of workdays between two dates.

You can learn more about the `EDATE` Google Sheets function on Google Support.