The method of making dynamic table tutorial is as follows:

Tools/materials: Lenovo Xiao Xin, windows 10, Excel20 10.

1. First enter = in the first cell of the date, then select the date cell above, here is A2, so it is = A2, and then press enter.

2. Then enter = in the second cell of the date, select the first cell, and then select+1. Enter, and then fill in all the lines to display the date.

3. Let's also enter = in the first cell of the week and then select the date cell above that week. Enter, display the same date, and then pull to the right to fill.

4. After completion, we select all cells of the date, right-click to select the cell format, select Custom, and enter "D" in the type.

5. Similarly, select Custom in all cells of the selected week, and enter "aaa" in the cell type.

6. The last dynamic attendance sheet is completed.