Format the cell directly and select the date type. Below I will demonstrate the detailed operation steps:

(computer model: MacBook Air, software version: Excel 202 1)

1. Open Excel, click the right mouse button and set the cell format;

2. A light gray box will pop up, and you can choose a matching date type;

3. Click OK in the lower right corner;

4. The operation of converting the table date into year, month and day format is completed!

The above is a tutorial on how to convert table dates into year, month and day formats. I hope it helps you ~