EDATEfunction 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
- Examples of using
EDATEformula not working?
- Similar formulas to
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.
ExamplesHere are a few example use cases that explain how to use the
EDATEformula 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.
EDATEnot working? Here are some common mistakes people make when using the
EDATEGoogle 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:
TODAYfunction 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.
DATEDIFfunction 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.
EOMONTHfunction 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.
WORKDAYfunction 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.
NETWORKDAYSfunction 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.