How can we help?
EOMONTH(DATE(1969, 7, 20), 1)
Returns a date representing the last day of a month which falls a specified number of months before or after another date.
start_date- The date from which to calculate the the result.
months- The number of months before (negative) or after (positive)
start_dateto consider. The last calendar day of the calculated month is returned.
start_dateinput to the function is either a reference to a cell containing a date, a function which returns a date object such as DATE, DATEVALUE or a date serial number of the type returned by the N
function. Excellentable 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.
EOMONTHdoes not auto convert number formats in the same way that Google Sheets does upon direct entry into cells. Therefore,
EOMONTH(10/10/2000,1)is interpreted as
EOMONTH(0.005,1), the quotient of 10 divided by 10 divided by 2000.
monthswill have their decimal components truncated. Therefore,
EOMONTH(A2,2.6)is equivalent to
Step 4. Once saved, your completed formula will display in a confluence page like this.