How to convert date to yYYY-MM-DD format in Excel?

Supposing you have a list of dates with mm/dd/yyyy format, and now you want to convert these dates to yyyy-mm-dd format as below screenshot shown. Here I introduce the tricks to quickly convert date to yyyy-mm-dd format in Excel.

Convert date to yyyy-mm-dd format with Format Cells

1. Select the dates you want to convert, and right click to display context menu, and select Format Cells from it. See screenshot:

2. Then in the Format Cells dialog, under Number tab, click Custom from the list, and type yyyy-mm-dd into the Type textbox in the right section. See screenshot:

3. Click OK. Now all dates are converted to yyyy-mm-dd format. See screenshot:

Quickly and easily convert date to other date formatting in Excel

Have you ever tried to convert a date to day, month or year only? The formulas maybe hard to remember, but the Apply Date Formatting of Kutools for Excel can quickly convert a standard date to the date formatting as you need as below screenshot shown. Dont, waite, click for 30 days free trial!

2. Then in the Apply Date Formatting dialog, you can select the date format you need from the Date formatting list, and preview the result in the Preview pane. To convert to yyyy-mm-dd format, just select 2001-03-14 from the Date formatting list. See screenshot:

3. Click Ok or Apply, and the dates are converted to the format you need. See screenshot:

Convert date to yyyy-mm-dd format

Easily add days/years/month/hours/minutes/seconds to a datetime in Excel

Supposing you have a date time format data in a cell, and now you need to add a number of days, years, months, hours, minutes, or seconds to this date. Normally, using formula is the first method for all Excel users, but it’s hard to remember all formulas. With Kutools for Excel’s Date & Time Helper utility, you can easily add days, years, months, or hours, minutes or seconds to a date time, moreover, you can caculate the date difference, or the age based on a given birthday without remembering the formula at all. Click for full-featured free trial in 30 days!