Returns the serial number of the last day of the month before or after a specified number of months.
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. |
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();