Convert Excel serial date 43391 to Date format?
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
-
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
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Works! Thank you.
Answers
-
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
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Works! Thank you.
-
Happy to help. Thanks for using the Community.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 202 Use Cases
- 515 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!