m = x2mdate(x)
t = x2mdate(x, 'datetime')
| Parameter | Description |
|---|---|
| inputs | Spreadsheet serial date numbers and optional output type datetime. |
| Parameter | Description |
|---|---|
| output | Nelson serial date numbers by default, or a datetime array when requested. |
Convert spreadsheet serial date numbers to Nelson serial dates or datetime values.
x2mdate adds the spreadsheet origin date 1899-12-30. Pass datetime as the second argument to construct datetime output directly.
Array-valued inputs keep their data shape when the operation supports arrays. Scalar operands are expanded where the implementation defines scalar expansion.
x2mdate(2)
x2mdate(2, 'datetime')| Version | Description |
|---|---|
| 2.0.0 | initial version |