Text to Date with variable month/day numbers

Options

I have a data source that is exporting date values as text strings. To make it worse, it is using M/D/YYYY as the format. This means that I have getting dates like this:

5/1/2022

5/10/2022

10/1/2022

10/10/2022

I am familiar with how to convert a MM/DD/YYYY string into a date, but I'm not sure how to adapt the formula for the variable digit count for Month and Day. I recall seeing something once that used the FIND function to identify the /, but I can't find it again after quite a bit of searching.

Thank you in advance for any help.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!