Convert datenums from the internal date format to the format used by Microsoft Excel. 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