Returns a date a specified number of months before or after another date.
start_date- The date from which to calculate the result.
months- The number of months before (negative) or after (positive)
Ensure that the
start_dateinput to the function is either a reference to a cell containing a date, a function which returns a date object such as
TO_DATE, or a date serial number of the type returned by the
Nfunction. Google Sheets represents dates and times as numbers; while conversion is automatic when a human-readable date is entered into a cell, functions only accept literal dates in numeric format.
EDATEdoes not autoconvert number formats in the same way that Google Sheets does upon direct entry into cells. Therefore,
EDATE(10/10/2000,1)is interpreted as
EDATE(0.005,1), the quotient of 10 divided by 10 divided by 2000.
Non-integer arguments to
monthswill have their decimal components truncated. Therefore,
EDATE(A2,2.6)is equivalent to
TO_DATE: Converts a provided number to a date.
N: Returns the argument provided as a number.
EOMONTH: Returns a date representing the last day of a month which falls a specified number of months before or after another date.
DATEVALUE: Converts a provided date string in a known format to a date value.
DATE: Converts a provided year, month, and day into a date.
Returns the date of the day which falls
months away from the given
In order to use the EDATE formula, start with your edited Excellentable:
Then type in the EDATE Formula in the area you would like to display the outcome:
By adding the values you would like to calculate the EDATE formula for, Excellentable will generate the outcome: