EOMONTH
function EOMONTH(arg1: any = null, arg2: any = null): numberDescription
Returns the serial number of the last day of the month before or after a specified number of months.
Parameters
- arg1
anydefault: null Is a serial date number that represents the start date.
- arg2
anydefault: null Is the number of months before or after the start_date.
Returns
numberTry It
const oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.EOMONTH("3/16/2018", 10);
oWorksheet.GetRange("C1").SetValue(ans);