"Windows Date Format" in Excel on Mac our internal software based on Zend throws Date Exception Errors for Excel Files from Mac Users. Same File stored on Windows passes.

So someone told me that in both OpenOffice and Excel for Mac (some here use the 2011 version) you can switch to "Windows Date Format" somehow but i can not find anything about this on google nor can i find it in the settings.

Any idea?
The instructions for switching to Windows date format on Excel for Mac can be found here.

So the steps are:


On the Excel menu, click Preferences.
Under Formulas and Lists, click Calculation.
Under Workbook options, select the Use the 1904 date system check box.