Convert datenums from the Microsoft Excel date format to the
format used by datenum. If set to 0 (default, Excel for
Windows), convention specifies to use the Excel 1900 convention
where Jan 1, 1900 corresponds to Excel serial date number 1. If set
to 1 (Excel for Mac), convention specifies to use the Excel
1904 convention where Jan 1, 1904 corresponds to Excel serial date
number 0.
Note that this does not take into account the Excel bug where 1900 is considered to be a leap year unless you give the "ExcelBug" option.
Excel does not represent dates prior to 1 January 1900 using this format, so a warning will be issued if any dates preceed this date.
See also: datenum, x2mdate.
Package: financial