EDATE
function EDATE(arg1: any = null, arg2: any = null): numberDescription
Returns the serial number of the date which comes the indicated number of months before or after the start date.
Parameters
- arg1
anydefault: null A serial date number that represents the start date.
- arg2
anydefault: null The number of months before or after the start date.
Returns
numberTry It
const oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.EDATE("3/16/2018", 7);
oWorksheet.GetRange("C1").SetValue(ans);