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

Jan 8, 2023 in Others 241 views

## 1 answer to this question.

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)
• 63,420 points

## Change date format of cell in excel from dd.mm.yyyy to yyy/mm/dd ( excel version 2013 )

Hello :)   Excel’s Format Cells function can quickly ...READ MORE

## How to subtract date only format "mm/dd" in excel?

I suppose Excel has handled December 21 ...READ MORE

## What is the shortest formula in excel to covert text date format e.g. 17 Jan, 2023 into regular date format like 1/17/2023?

The SUBSTITUTE() method can be used to ...READ MORE

## Add a correct format date in Excel file with Python openpyxl

Use just datetime.fromisoformat(row['Date']) but I didn't have ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert column in excel date format (DDDDD.tttt) to datetime using pandas

Given # s = df['date'] s 0 ...READ MORE

## How to change two different date format into single date format in excel

With data in A2, in B2 enter: =IF(ISNUMBER(A2),A2,DATE(LEFT(A2,4),MID(A2,6,2),RIGHT(A2,2))) and apply your format ...READ MORE