Excel import and date

thomas · September 23, 2019, 1:30pm

Hi there,

i have a problem importing excel files and date. My date in excel is 42158 so it’s 03/06/2019 and easymorph read 03/06/2015

Any solution ?

thx.

dgudkov · September 23, 2019, 1:59pm

It's 2015 in Excel 2010. What am I missing?

thomas · September 23, 2019, 2:16pm

Argh… seems to be an Excel issue so… when i write 28/03/2019 it convert it to 42182. I can’t figure why …

Edit : I found an advanced option ‘use the from 1904 calendar’. Is easymorph able to detect that ?

dgudkov · September 23, 2019, 3:19pm

No, EasyMorph doesn’t detect that.

You can use the addmonths() function to add 48 months to every date.