Excel dynamic attendance sheet creation tutorial_can be used for a lifetime

Excel is an office software that is widely used in our work, study and daily life. The attendance sheet is one of the most widely used Excel forms. So, do you know how to make a dynamic attendance sheet? In this article, PHP editor Xigua will give you a detailed tutorial to teach you how to make an Excel dynamic attendance sheet that can be used for a lifetime. Friends who are interested may wish to read on. Mastering this skill will allow you to say goodbye to the traditional manual attendance method and easily realize automatic statistics of attendance data.

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

Enter = in the second cell of the date and select the first cell after 1. After pressing Enter, select all rows so that the date will be displayed.

3. Next, we also enter = in the first cell of the week, and then select the date cell directly above the week. Press Enter, and then pull to the right to fill in the same display date.

#4. After finishing, we select all the cells of the date, right-click and select [Cell Format], select Custom, and enter [d] in the type.

#5. Similarly, select all cells of the week, select Custom in the cell type, and enter [aaa] in the type.

#6. The last dynamic attendance form is completed. No matter how you modify the month at the top, the date and week below will change accordingly.

Isn’t it very simple? In this way, you don’t need to change the date of the attendance sheet every month. You can just copy it again, saving time and effort. oh.

The above is the detailed content of Excel dynamic attendance sheet creation tutorial_can be used for a lifetime. For more information, please follow other related articles on the PHP Chinese website!