Formatting Dates
I am copy and pasting reference data that contains dates as text. How can I link to a field and get it to format it as a date. The data looks like this Tuesday, August 16, 2022, but Smartsheet does not recognize it as a date.
I tried this
=[OPD Data]24{DATE(2021,5,5)}
Answers

Hi @smeyermmec
This formula will work and should work for all months, if the structure of your import data changes you will need to tweak the formula
=LEFT(RIGHT([Test date]@row, 8), 2) + "/" + IF(CONTAINS("January", [Test date]@row), 1, IF(CONTAINS("February", [Test date]@row), 2, IF(CONTAINS("March", [Test date]@row), 3, IF(CONTAINS("April", [Test date]@row), 4, IF(CONTAINS("May", [Test date]@row), 5, IF(CONTAINS("June", [Test date]@row), 6, IF(CONTAINS("July", [Test date]@row), 7, IF(CONTAINS("August", [Test date]@row), 8, IF(CONTAINS("September", [Test date]@row), 9, IF(CONTAINS("October", [Test date]@row), 10, IF(CONTAINS("November", [Test date]@row), 11, IF(CONTAINS("December", [Test date]@row), 12, "Error")))))))))))) + "/" + RIGHT([Test date]@row, 4)
Hope it helps
Thanks
Paul
Help Article Resources
Categories
Check out the Formula Handbook template!