I have just run up a Worbook for you at:-
http://www.pierrefondes.com/
Look at the first item on the home page (number 20).
1. The numbers (1 to 30 in row 1) need to be changed for your student names.
2. If a student has attended enter 1 in his / her column for the correct day.
If you look at column B student has attended every day for the whole year so
at cell B 367 his / her attendance is 365.
3. If a student has not attended enter 0 in his / her column for the correct
day.
If you look at column C student has failed to attend every day for the whole
year so at cell C 367 his / her attendance is 0.
4. You could enter a 0.5 for half days.
If my comments have helped please hit Yes.
Thanks.