Converting CSV Date with VBA

[MojoJojo2023]

Hello all,

I have started receiving a csv file where the month is being presented (with General formatting) as:

202405

I need to convert the date to "May-24" but converting it to a date leaves me with "Feb-54".

Has anyone encountered this issue before? I'm trying to use a For... Loop to convert each cell in a range to this date format.

 

[Anthony47]

202405 will obviously be translated to Feb 28, 2454
You can obtain the string May-24 using in your loop something like

    myFDate = Format(DateSerial(Left(Cells(I, "A"), 4), Right(Cells(I, "A"), 2), 1), "mmm-yy"

This assumes I is the pointer to the row and the value to be converted is in column A, adapt to your situation

If you need a true date, omit Format and the format string and you will get May 1st, 2024

Try...

 

[MojoJojo2023]

That works! Thank you, Anthony!

 

[Anthony47]

Thank you for the feedback