Convert Text to Excel Date

Hi There,

I am extracting some dates from a system. However, Excel doesn't recognize it as a date field.
Is there any solution please to this issue by using only formulas? (not through text to column and not through formatting cells)
Sample sheet attached.

dd1.png

Thanks in advance.

Originally Posted by TMS

Select all the dates. Use Data | Text to Columns | Delimited, Next, Next, Date: DMY, Finish

Hi TMS, Thanks. But as mentioned in my post, I am looking for a formula. (not text to column) as I am going to extract this data from a system many times every day to update a report.
Text to column will not be practical in my case.

It didn’t work. I got a #VALUE! error

Try this:

=DATE(RIGHT([@Date],4),MID([@Date],4,2),LEFT([@Date],2))

Originally Posted by Phuocam

Try this:

=DATE(RIGHT([@Date],4),MID([@Date],4,2),LEFT([@Date],2))

Thank you very much.. it worked!