Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Date conversion

J. Craig Williams
J. Craig Williams ✭✭✭✭✭✭
edited 12/09/19 in Archived 2016 Posts

I feel like I'm off my game today.

I hope I'm wrong here but this is what I have.


Sheet 1 has a Date column 

For other design issues, that date is linked to a Text/Number formula on Sheet 2.


In sheet 2, I want to take the date and compare it to a real date in the sheet.


Addiing =[Text Column]23 to a date field results in a text.

Even if the text 'looks' correct ("07/01//16")


Am I missing a formula to convert that directly to a date?




=DATE(VALUE(RIGHT([Text Column]23, 2)) + 2000, VALUE(LEFT([Text Column]23, 2)), VALUE(MID([Text Column]23, 4, 2)))


seems like a lot of effort to do that on my own.

Is there another way I'm just brain-farting on at the moment?


If not, I suggest that there should be.






This discussion has been closed.