You sure it is 3 years and 1 day and not 4 years and 1 day which is caused by
using two different date systems in separate workbooks?
Tools>Options>Calculation Tab has a checkmark for 1904 date system which Mac
From JE McGimpsey(Mac user) posting........................
The workbooks have different base dates. The one you're copying from is
set to the WinXL default 1900 date system (base date 31 December 1899)
while the one you're copying to has the MacXL default 1904 date system
(base date 1/1/1904). Since XL stores dates as integer offsets from the
base date, you're seeing a 4 year + 1 day shift (the 1 day is an error
in the 1900 system which includes a phantom 29 February 1900).
You can change the date system of your destination workbook (date
systems are workbook specific) choosing Preferences/Calculation and
unchecking the 1904 date system checkbox.
As an alternative, you can enter 1462 in a cell, copy the cell, then
select the cells with the advanced dates. Choose Edit/Paste Special,
selecting the Values and Subtract radio buttons. Click OK.
End JE posting...............................
Gord Dibben MS Excel MVP
On Thu, 22 Feb 2007 17:44:15 -0800, matelot <matelot@>