1. Give an example as an example. First, open the sample file in excel.

2. The function used to display the day of the week is called weekday function. First, enter = weekday in the cell, and then select the target cell.

3. At this time, the page will automatically jump out of the dialog box and ask for a return number. Because excel defaults Sunday to the beginning of the week, the first line returns the number 6.

4. Press ctrl after selection and double-click fill handle to get a list of dates.

5. If you want to set Monday as the beginning of the week, you can select the second line.

6. If you want to format the number as x weeks, you can right-click the cell, select Format Cell, and then select Wednesday under the date.