Date format conversion in Excel

Question

I have a list of dates, which seem to be in dd/mm/yyyy hh:mm format ( Ex - 12/13/2022 12:16 AM ) , which is incorrect. I need to change to mm/dd/yyyy hh:mm format.

I tried the formula 

=IF(H2="","",IF(DAY(H2)>12,DAY(H2)&"/"&MONTH(H2)&"/"&YEAR(H2),VALUE(DATE(YEAR(H2),DAY(H2),MONTH(H2)))))

But the result is #Value

Answer 1

You appear to be misunderstanding the point: an Excel datetime format is a regular number, where 1 denotes a day beginning on January 1st, 1900.

I'll demonstrate how it appears on my PC.

As you can see, there are two ways to describe the thirteenth of December, 2022:

• format dd/mm/yyyy : 13/12/2022 (European style)
• format mm/dd/yyyy : 12/13/2022 (American style)