Implement 1904 Date System

Microsoft Excel supports two date systems: 1900 date system (the default date system implemented in Excel for Windows) and 1904 date system. The 1904 date system is normally used to provide compatibility with Macintosh Excel files and is the default system if you are using Excel for Macintosh. You can set the 1904 date system for Excel files using Aspose.Cells.

To implement 1904 date system in Microsoft Excel (for example Microsoft Excel 2003):

1. From the Tools menu, select Options, and select the Calculation tab.
2. Select the 1904 date system option.
3. Click OK.

Selecting 1904 date system in Microsoft Excel
See the following sample code on how to achieve this using Aspose.Cells APIs.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
// Initialize a new Workbook
// Open an excel file
Workbook workbook = new Workbook(dataDir+ "book1.xlsx");

// Implement 1904 date system
workbook.Settings.Date1904 = true;

// Save the excel file
workbook.Save(dataDir+ "Mybook.out.xlsx");