WOLFRAM

Wolfram Language & System Documentation Center

"ExcelDate" (Interpreter Type)

A numerical date in the Microsoft Excel standard.

Details

  • "ExcelDate" can be used in Interpreter and related constructs, including deployed smart form fields.
  • Use of "ExcelDate" does not require connectivity to the Wolfram Cloud.

Allowed Forms

  • 12345number of days since epoch (December 30, 1899)
    123.45a time of day on the 123^(rd) day since epoch

Restriction Specifications

Interpretation

Examples

Basic Examples  (3)

Interpret Excel dates:

Wolfram Language code: Interpreter["ExcelDate"]["30591"]
Wolfram Language code: Interpreter["ExcelDate"]["51212.13"]

Restrict the value to be within a given range:

Wolfram Language code: Interpreter[Restricted["ExcelDate", {DateObject[{1933, 9, 1}], DateObject[{1933, 9, 1}] + Quantity[3, "Month"]}]]["12345.67"]

Set a resolution:

Wolfram Language code: Interpreter[Restricted["ExcelDate", {DateObject[{1933, 9, 1}], DateObject[{1933, 9, 1}] + Quantity[3, "Month"], "Day"}]]["12345.67"]