2. Select A 1:H 1, and center the points after merging.
3. Double-click the cell and enter the formula: =TEXT(NOW (), "yyyy mm monthly attendance sheet"). (Note: In order to prevent this function from changing automatically in June, it can be saved as the value at the end of the month. )
4. Enter 1 in B3 and fill in the date on the right. In this case, it is 7 days, that is, the current month 1 to 7. (Note: I am shorthand. The actual situation can be filled in to 3 1 and judged by IF. If it exceeds the maximum number of days in this month, it is empty. )
5. Enter B2 as the first day of a month, fill it in to the right, then select the filled date, right-click and select Set Cell Format. (Note: Time formula can also be used here. If the month and year are generated by the drop-down menu, both here and the header can be automatically generated by the formula and will not change with time. )
6. Enter: aaaa in the custom location, and then click OK. This shows the day of the week.
7. Enter the attendance sign in the unused blank column, then select it, right-click and click the definition name.
8. Point to B4, select the data above, and then click Data Validity-Data Validity.
9. Select the sequence allowed in the settings, write it to the source (= option 1), and then click OK.
10. Let's make a statistic later. On the right side of the recording area, set the statistical format as shown below. Where I4:N4 is necessary for input formula statistics.
1 1. Double-click the I4 cell and enter the formula: =COUNTIF(B4:H4, I3). (Note: The reference to the original area and header in the formula is a special problem. )
12. Then pull the first statistic to the right and all the statistics will come out.