How to convert date to year month day format

How to convert date into year-month-day format

As shown in the picture, it is a group of date data. Now we need to The date is converted into the format of month and day. The specific operation is as follows

Recommended: "excel tutorial"

Select column D and click Right-click the mouse, as shown in the picture, and find "Format Cells, as shown in the picture

Click "Format Cells," and find "Number" in the pop-up dialog box , as shown in the picture

Under the "Number tab, find "Date", and select "March 7, 2001" under the type, as shown in the picture

Click "OK" and you will find that the date is automatically converted to year, month and day format, as shown in the picture

The above is the detailed content of How to convert date to year month day format. For more information, please follow other related articles on the PHP Chinese website!