TRY NEW VERSION

DAY

DAY(arg1) → { number }

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

Parameters:

Name Type Description
arg1 number

A number in the date-time code.

Returns:

Type
number

Example

Copy code
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