How to extract Date from String "Sunday, December 12 4:25 PM"
Options
Fahad F
✭
Need to transform the month and date into date format from "Sunday, December 12 4:25 PM"
Answers
-
@Fahad F Have you tried =DATEONLY([your date])?
dm
-
It gives invalid data type error since its a text field that's filled from another sheet that's auto-populated.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!