Date conversion

J. Craig Williams

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?

 

This:

 

=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.

 

Craig

 

Kennedy Stomps

Hey Craig-- Can you share the sheet with me? I tried to follow the steps you outlined on my end and I'm seeing the date show up as a "real date" so I assume I must be doing something wrong.