Date Issue

[DRExcel515]

This is an odd one (at least to me). So I have a file I received from our legal department with dates in column E that when I copy and paste them into a new spreadsheet the date drops 4 years for some reason.?

So for example the date in cell E4 in the legal file is 02/28/2017... when I copy and paste into a new spreadsheet the date automatically turns to 02/27/2013 and I have no idea why? I've tried formatting it differently but it makes no difference. Any suggestions?

Thanks!

 

[steve the fish]

The legal file will be using the 1904 date system. I think you need to add 1462 to those dates to convert them.