Change date format

[kmdavila]

Hello all and thank you for any help in advance.

I have an online database of dates that I need to extract every week. When I extract I get an excel file, but this excel file only extracts the dates in French format DD/MM/YYYY. I need to these dates in a formula, but the formulas do not like the dates in the DD/MM/YYYY format because it sees it at text. I need to get them in MM/DD/YYYY format. I've tried to just change the format in the menu bar but nothing seems to to work. I posted pictures and the formula below.

ScreenHunter_2.jpg
ScreenHunter_3.jpg

=Month(VLOOKUP(C6,Sheet5!A3:AK40,8))&"/"&DAY(VLOOKUP(C6,Sheet5!A3:AK40,8))&"/"&Year(VLOOKUP(C6,Sheet5!A3:AK40,8))

[sweep]

Hi,

Maybe convert the date longhand like so?

=DATE(RIGHT(A1,4),MID(A1,FIND("/",A1)+1,2),LEFT(A1,2))