How to set the formula for automatically displaying the day of the week in EXCEL tables?

1. First open the excel form, and you need to fill in all the dates corresponding to the week in the form, as shown below.

2. Select the cell corresponding to the first date and enter the = sign, as shown below.

3. Then enter the formula = text (B2, "AAAA"), where B2 is the meaning of the corresponding date cell, as shown below.

4. When inputting the formula, all punctuation marks must be English punctuation marks, as shown below.

5. After entering the formula, click Enter, and the system will automatically calculate the week corresponding to the date, as shown below.

6. Finally, drag the first cell to automatically fill in the other dates below, so that you can calculate the day of the week in all the dates with one click, as shown below.