TRY NEW VERSION

EOMONTH

EOMONTH(arg1, arg2) → { number }

Returns the serial number of the last day of the month before or after a specified number of months.

Parameters:

Name Type Description
arg1 any

Is a serial date number that represents the start date.

arg2 any

Is the number of months before or after the start_date.

Returns:

Type
number

Example

Copy code
builder.CreateFile("xlsx");

const oWorksheet = Api.GetActiveSheet();

var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.EOMONTH("3/16/2018", 10); 

oWorksheet.GetRange("C1").SetValue(ans);

builder.SaveFile("xlsx", "EOMONTH.xlsx");
builder.CloseFile();

Resulting document