Attendace tracking with 12 month rolling calendar and different types of absences

Hello all. I am trying to put together a spreadsheet with a rolling 12 month calendar to track unexcused absences. It has point values for different types of absences, which I cannot change.

The point values are:
T1 < 15 minutes (.25 points)
T2 > 15 minutes - 2 hours (.5 points)
U > 2 hours (1.0 points)

The T's are for tardy, and U is for unexcused absences. The spreadsheet I have built will have a tab for every employee, and has a cell for each day of the month. I would like to be able to enter U or T1 or T2 and have a table enter the date and the appropriate point value. In this table, would like it to accrue the total sum of the point for the rolling year.

I was trying to make it a calendar format, where I could click on a date and enter the appropriate info, but that seems a bit too complicated for me right now. Something where you could select the current year and it would change the dates accordingly while still being able to update a summary table. Would that be a complicated process?

Searches for something like this have not been very successful I think due to the different point values. All of the sheets I have found have 1 absence type, or they are built to track the amount of hours left in a vacation bucket which I don't need.

Would anyone be able to assist me in this, or point me in the right direction? I am pretty new to excel...

Thank you!