EDATE
TheEDATE
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.
 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:
 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.  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 theEDATE
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.
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
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.
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.