Convert Excel serial date 43391 to Date format?

Robert Charles
Robert Charles ✭✭✭
edited 12/12/20 in Formulas and Functions

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.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!