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
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!