# EOMONTH

### Name of Formula:

`EOMONTH(DATE(1969, 7, 20), 1)`

`EOMONTH(A2, 1)`

`EOMONTH(40909, -2)`

### Definition of EOMONTH:

Returns a date representing the last day of a month which falls a specified number of months before or after another date.

### Syntax for FORECAST:

EOMONTH(start_date, months)

• `start_date` - The date from which to calculate the the result.

• `months` - The number of months before (negative) or after (positive) `start_date` to consider. The last calendar day of the calculated month is returned.

### Notes:

• Ensure that the `start_date` input to the function is either a reference to a cell containing a date, a function which returns a date object such as DATE 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.

• `EOMONTH` does 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.

• Non-integer arguments to `months` will have their decimal components truncated. Therefore, `EOMONTH(A2,2.6)` is equivalent to `EOMONTH(A2,2)`.

### Step 3. Fill in the 2 values- In this example I have chosen 2 values that are the same. (see another possible outcome below)

Step 4. Once saved, your completed formula will display in a confluence page like this.

### Need Help?

Can't find the answer you're looking for? Don't worry we're here to help