Convert Excel serial date 43391 to Date format?

Robert Charles

The Excel spreadsheet I am uploading has serial format dates: 43391 needs to be converted to 10/18/2018. I want the conversion to be done by Smartsheet every time I merge on Upload. 1/1/1900 =1. So, 43391 is the number of days from 1/1/1900 to 10/18/2018.

Mark Cronk

Hi @Robert Charles ,

Try creating a date column with the column formula:

=DATE(1900,1,1) - 2 + [excel serial]@row.

Where [excel serial] is the name of your column with the excel serial date.

Your serial date column needs to be text/number column.

Work?

Mark

Robert Charles

Works! Thank you.

Mark Cronk

Hi @Robert Charles ,

Try creating a date column with the column formula:

=DATE(1900,1,1) - 2 + [excel serial]@row.

Where [excel serial] is the name of your column with the excel serial date.

Your serial date column needs to be text/number column.

Work?

Mark

Robert Charles

Works! Thank you.

Mark Cronk

Happy to help. Thanks for using the Community.

Mark