when i move or copy a sheet, dates change by one day??

[Devo]

I have workbook with mutiple sheets, When I move or copy a sheet to a new
book, all the dates change by negative one day. What's up??

 

[Nick Hodge]

Devo

Go to Tools>Options>Calculation and uncheck 1904 date system

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk

 

[Devo]

Devo

Go to Tools>Options>Calculation and uncheck 1904 date system

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk





That's got it!!!

Thanks a lot!!

Regards;
Devo