How to convert the date format of column A to the date format of column C

[rayhen]

M/D/Y >>>>>> YYYY/MM/DD

Can someone please help me ? It would be much appreciated. Thanks in advance

[Gregb11]

You can format the date by formatting the cell in whatever date layout you want. The issue with your file is that the "dates" shown are not recognized as Dates in Excel, but Text.
You can enter this formula:
=DATEVALUE(A4) to turn it into a real date, and then format it however you want.

[rayhen]

@Gregb11, thank you for your quick response, I have an error here

[Gregb11]

Hmm, I don't know why you would have an error. Please see my attachment and let me now if it shows an error for you.

[josephteh]

Try this:

Please Login or Register  to view this content.

[rayhen]

@josephteh Excellent solution. Thank you both, thank you very much for the solution.