Reverse Concatenate?

Jeff_Berman

If I have a cell with a string of data such as the following:

CONV-MB20210905-01

Is it possible to write a formula in another column to extract the date? In this case it would be 09/05/2021

Thanks

Leibel S

@Jeff_Berman

Not understanding what the difference is.

Leibel S

@Jeff_Berman

Is it always set up this way?

if yes, see below (change the column name to match yours)

=DATE(VALUE(MID(String@row, 8, 4)), VALUE(MID(String@row, 12, 2)), VALUE(MID(String@row, 14, 2)))

Jeff_Berman

@Leibel Shuchat this is great! Thank you! One follow-up question. One of those sets of data that is being extracted is a date in the format of 20210921. Is there a formula to populate a date (date column type) with the value 9/21/21?

Leibel S

@Jeff_Berman

Not understanding what the difference is.

Jeff_Berman

Sorry @Leibel Shuchat - moving too fast