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 365 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)
answered Jan 8, 2023 by
• 63,720 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

## Is there an efficient way to do this excel function

Use vlookup(): VLOOKUP(E2,\$B\$4:\$C\$8,2,1) READ MORE

## Excel - How do I round a date type to the next hour if it is more than one minute

Add almost 30 minutes and it'll get ...READ MORE

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

Hello, yes u can find your birthdate using ...READ MORE

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

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