Date Conversion

[Lean_Sawko]

Hi everyone,

I have an excel with a date format column and I want to convert it to General so I can concatenated it later on.

e.g: "10/25/2019" transformed to "43763"...... 

What do you recommend to do here?

[echuong1 · Accepted solution]

I generally see people trying to go the other way around!

The number formatted date is just the days since 1900-01-01 with a 2 day difference. You can use datetimediff() to calculate this.