Need scheduling help with Excel database

Hello. I am in dire need of advice of how to create this database within Excel 2013.

Just a run down of what Im trying to do:

I will have a list of students that would be attending classes on a weekly basis, at their specific day and time of the week, Mon-Friday anywhere between 8 am and 8pm, i.e., STUDENT 1 comes to class every Wed. at 930am - 1030 am (there could possibly be a few students in a single lesson)

They are very busy and are going to be missing lessons for sure, however they are able to make-up these ABSENT lessons at anytime.

For example, lets say STUDENT 2 doesn't show up at her lesson time on Thursday at 6pm (ABSENT) ... I can ask STUDENT 1 to make-up for his ABSENT lesson on last Wed (if he isnt too busy, of course), and then once he takes that lesson, that absent mark is taken away. It pretty much all about accountability.

So, for every lesson a student misses they can make up at anytime there is an open slot even if they fill in on another students lesson time...or even with each other ... the main point is to show who is coming to class and who isn't.. which will be in a quarterly report.

Pretty much, everyone starts at 0 (ABSENT days) 0 = perfect attendance

There are much more aspects to this system, but this is the first part I'm trying to get thru. Adding and taking away..if that makes sense.

How do I create such a database? Again, there are other parts to this, so if it is necessary to know the rest of what needs to be, please let me know and I will happily explain it more in depth.

Any and all help is greatly appreciated. Thank you very much!!!

B