I teach college English, and I have started to use Excel calendars for attendance. I like to have all the attendance for a class on one page for quick reference. Templates I have downloaded, though, include all the days in each week. How can I set up--quickly--a calendar containing only Mondays and Wednesdays or only Tuesdays and Thursdays?

Also, I want an automatic record of each student's attendance tallied for grading purposes. Students are allowed two absences, after which I subtract one point from their averages. Three tardies add up to one absence. I would like to import the result to the student grade sheet, showing the number of absences to be deducted from the student's average. I have worked out a way to accomplish this, but it isn't exactly a time saver. Any ideas?

P = present
A = absent
T = tardy or .33 P

Craig