DAYS
function DAYS(arg1: number = null, arg2: number = null): numberDescription
Returns the number of days between the two dates.
Parameters
- arg1
numberdefault: null Start date from which days will be counted.
- arg2
numberdefault: null End date until which days will be counted.
Returns
numberTry It
const oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.DAYS("3/31/2018", "3/16/2018");
oWorksheet.GetRange("C1").SetValue(ans);