DAY

DAY(arg1) → { number }

Returns the day of the date given in the numerical format, a number from 1 to 31.

Parameters:

Returns:

Type

number

Example

builder.CreateFile("xlsx");

const oWorksheet = Api.GetActiveSheet();

var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.DAY("2018/3/16"); 

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

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

Resulting document