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, 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.
  
  
• 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 1.  To begin to use the EOMONTH formula, start with the Excellentable you would like to edit.

Step 2. Then type the EOMONTH formula into the cell you have chosen to display the outcome:

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. 

	A	B	C	D
1	State	Population	Total area in mi2	Land area in mi2	Water area in mi2	House seat(s)
2	Alabama	4833722	52,420 (135,767)	50,645 (131,170)
3	Alaska	735132	665,384 (1,723,337)	570,641 (1,477,950)
4	Arizona	6626624	113,990 (295,233)	113,594 (294,207)
5	Arkansas	2959373	53,179 (137,733)	52,035 (134,770)
6	California	38332521	163,695 (423,968)	155,779 (403,466)
7	Colorado	5268367	104,094 (269,602)	103,642 (268,432)
8	Connecticut	3596080	5,543 (14,356)	4,842 (12,541)
9	Delaware	925749	2,489 (6,446)	1,949 (5,048)
10	Florida	19552860	65,758 (170,312)	53,625 (138,888)
11	Georgia	9992167	59,425 (153,910)	57,513 (148,958)
12	Hawaii	1404054	10,932 (28,314)	6,423 (16,635)
13	Idaho	1612136	83,569 (216,443)	82,643 (214,044)
14	Result:	42643

	E	F	G
1

Date