EDATE

• How to use EDATE formula?
• Examples of using EDATE formula
• EDATE formula not working?
• Similar formulas to EDATE

Usage

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

=EDATE(start_date, months)

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

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.

Calculate project deadlines

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

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.

Related Formulas

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.

Learn More

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