Trying to calculate school attendance in Excel 2010

Here is the spreadsheet without names and student numbers. I have it set up to flag whenever they reach seven unexcused absences and tardies, but I would like a new column to begin at one when they reach 7, go to 2 when they reach 8, and so on. Also, when they reach those absences and tardies, they will be required to serve detention, so I want to insert a formula to make the new column decrease once a detention have been served.