How to make EXCEL automatically display the day of the week after entering the date?
1. Turn on the computer, directly enter our excel software, then find and select the date we want and automatically display the cell of the current day of the week.
2. After selection, we click the right mouse button on the cell, and then select the "Cell Format" menu in the right-click menu to enter.
3. After opening "Cell Format", we select the "Number" column, then select the "Date" menu in the left menu, and select the date format we like or need under the date. For the convenience of subsequent operations, it is recommended not to select the date format preceded by *.
4. After selection, we continue to select the "Custom" menu from the menu on the left, and then find the "Type" setting below.
5. We click on the text content under "Type" and then change it to the style shown below, that is, change the format after the date and add "aaaa". This solves the problem of making EXCEL automatically display the day of the week after entering the date.