Switching around Credit Card Expiration Dates

[AngryConsuela]

Hey guys, this forum has been super helpful for me in the past so I registered to ask a question I'm not able to figure out on my own rn. I work for a credit card processor and need help formatting expiration dates for use in a gateway that requires them in a specific format. The original info I'm pulling comes as yy/mm, and I need a formula to switch it to mm/yy.

Ex. Original data "23/01"
Ex. Converted Data "01/23"

I don't want to adjust the thousands of cards I need to do this for manually lol.

Thanks in advance for the help!

 

[ranman256]

=right(vDate,2) & "\" & left(vDate,2)

 

[AngryConsuela]

=right(vDate,2) & "\" & left(vDate,2)

I'm a little confused, I have the original data in column E and the formula for converting it that you suggested in column F and it gives me a #NAME? error

 

[jtakw]

Hi,

Try this:

Book3.xlsx
	E	F
1	23/01	01/23
Sheet801

Cell Formulas
Range	Formula
F1	F1	=MID(E1&"/"&E1,4,5)

 

[AngryConsuela]

I'm a little confused, I have the original data in column E and the formula for converting it that you suggested in column F and it gives me a #NAME? error

My bad, I'm dumb, this works, thank you so so much!!