Date from excel

[Kjaer]

Hi

I have an excel fil with a column of dates in the format dd-mm-yyyy. But when I import the file the dates are listed i excelnumber (ex. 28-02-2022 becomes 44620). How can I convert this column to dates again?

[Adrian_T · Accepted solution]

Hey @Kjaer, the ToDate formula will work for you here. 😊

Specifically,

ToDate(7000) returns 1919-03-01 as a date.

This previous community post should give your more clarity as well!

[gautiergodard]

hey @Kjaer 

You can use this formula, also attaching workflow for your reference!

if isnull([Field1]) then DateTimeParse(DateTimeAdd(ToDateTime('1900-01-01'),[Field1],'days'),'%Y-%m-%d') else [Field1] endif

Hope this helps!

[Kjaer · Accepted solution]

It works :-)) Thanks.