Excel import and date

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.

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

image

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 ?

No, EasyMorph doesn’t detect that.

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