Need to convert excel month (43220, 43251, etc) to actual date?

[CapnShanty]

Hello, I have a column that's wierdly the excel 'math month' so like 43220 and 43251 and such. I need to convert those back into actual human dates... I tried format and date but couldn't get them to work. Any ideas?

[v-yulgu-msft]

Hi @CapnShanty,

Are those values formatted as "Whole number" after imported into desktop?

If so, please directly change the data type to "Date".

Best regards,

Yuliana Gu

[dobregon]

Try to create another column 

month_NUMBER = MONTH(CELL 43220)

I have checked and that number is the 30th of April of 2018

and if you create the column for MONTH(COLUMN NUMBERS) and then apply format like "general" or "decimal" then you can see a 4.