unchecking 1904 date system for all excel files

[lyh1124]

I discovered that the dates were off on my excel files, and that I
need to uncheck the 1904 option in the preferences.

However, I am wondering, if there is a way to do this for all of the
excel documents I have, instead of having to go to every one
individually.

 

[Bob Greenblatt]

I discovered that the dates were off on my excel files, and that I
need to uncheck the 1904 option in the preferences.

However, I am wondering, if there is a way to do this for all of the
excel documents I have, instead of having to go to every one
individually.

If the workbooks already exist, you will have to do it manually for each
one. Yu could, of course write a short Vba routine to do it for you. Simply
unchecking the box will shift the date by 1462 days. You may then also have
to apply this correction to get the dates correct in the other system.