"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:

Restrict the value to be within a given range:

Set a resolution: