How to convert date to different or specific format in Excel?

If you want to convert the standard date to other date formats in Excel, how can you do? Here, I have three methods that can solve this job.

Convert date to different format with Format Cells

Convert date to different format with formulas

Convert date to different format with Apply Date Format

Convert date to different format with Format Cells

In Excel, you can convert date to other date format in the Format Cells function.

1. Select the dates you want to convert, right click to select Format Cells from context menu.

2. In the Format Cells dialog, under Number tab, select Date from Category list, and then select one format you want to convert to from the right section.

3. Click the OK button to apply the new format.

Convert date to different format with formulas

If you want to use formula to convert date to year/month/day only, you can do as below:

Convert date to year =TEXT(A1,"yyyy")

Convert date to month =TEXT(A1,"mm")

Convert date to day =TEXT(A1,"dd")

Convert date to different format with Apply Date Formatting

If you have Kutools for Excel, its Apply Date Formatting function will do you a big favor.

After installing Kutools for Excel, please do as below:（Free Download Kutools for Excel Now!)

1. Select the dates you want to convert format, and click Kutools > Format > Apply Date Formatting.

2. In the popping out dialog, select the date format you need from left pane, and preview in right section.

3. Click Ok or Apply to convert the dates.

  Demo