You can use the following syntax to convert a datetime to a date in Excel:

**=TEXT(A2,"m/d/yyyy")
**

This particular formula converts the datetime in cell **A2** to only a date.

For example, if cell **A2** contains **1/1/2023 2:14 AM** then this formula would return **1/1/2023**.

The following example shows how to use this formula in practice.

**Example: Convert Datetime to Date in Excel**

Suppose we have the following column of datetimes in Excel:

Suppose we would like to convert each datetime in column A to only a date.

To do so, we can type the following formula into cell **B2**:

**=TEXT(A2,"m/d/yyyy")**

We can then click and drag this formula down to each remaining cell in column B:

Column B now displays each datetime from column A as only a date.

**How This Formula Works**

Recall the formula that we typed into cell **B2** to convert the datetime in cell **A2** to a date:

**=TEXT(A2,"m/d/yyyy")**

This formula uses the **TEXT** function, which allows you to change the way that a number appears by using a specific format code.

In this formula, we used the format code of **m/d/yyyy** which tells Excel to display the month (**m** = month as 1 or 2 digits), day (**d** = day as 1 or 2 digits) and year (**yyyy** = year as 4 digits) with slashes in between them.

The end result is that we’re able to display only the portion of the datetime that contains the date.

The time portion of the datetime is simply not shown at all.

**Note**: You can find the complete documentation for the **TEXT** function in Excel here.

**Additional Resources**

The following tutorials explain how to perform other common operations in Excel:

Excel: Calculate Difference Between Two Times in Hours

Excel: Calculate Difference Between Two Times in Minutes

Excel: How to Calculate Average Time