Microsoft Excel and Apple- Date issues

Be careful when interchanging spreadsheets between an Apple based Excel and other computers as the dates work differently between Apple’s Excel  and Windows based Excel.

In certain circumstances, the Apple Excel will show all the dates as four years later then they really are. This is because of the date convention used where Apple Excel starts its dates in 1904 and Windows based Excel uses 1900 as its start year.

There is a setting in Windows based Excel which can change the dates to use 1904 but in general you should always check your dates if you move spreadsheets between Apple computers and Windows based computers.

 

Learn more at our live advanced Excel courses in South Africa. Visit www.AuditExcel.co.za Live Excel Training page