How to display date and week at the same time in Excel table

The following is sample data.

Select all data.

Right-click the mouse and select [Format Cells].

The dialog box for formatting cells will pop up. Click [Customize] in the list on the left.

Then add four [AAAA] after [Type].

After clicking OK, the day of the week will be automatically displayed behind the time.

The above is the detailed content of How to display date and week at the same time in Excel table. For more information, please follow other related articles on the PHP Chinese website!