"Harald Staff" wrote:

"N Harkawat" skrev i melding
...
Looks like both have different date system
Change them to follow the same date system by going into
TOOLs-OPtions-Calculation
and uncheck 1904 date system from both your Windows machines.
If using Mac I guess leave them checked

This checkbox clicking will shift existing dates 4 years 1 day, just as the
mentioned copying does. Be very careful with this.

This whole thing comes from those computers' date systems. 1 is a day, and
date cells really contain "number of days since day 1". Problem is "day 1
was when ?". Steve says new year 1904, Bill says four years earlier.

Bill even invented a date and started with January 0 1900 <g


Peo