using vba coding need to prepare the following chart

i have a report card data with names ,roll no. and scores of students. i want to write a program so that this data is set up and the dates where student were not there(represented by n/a) no score is given and should not be there in the report card data.attached the files.

Sub report_card()
Dim givendate As Date
t = InputBox("enter any givendate")
If givendate = "n/a" Then
MsgBox "do not show"
Else
MsgBox score
End If
End Sub

i have done it like this but it is showing error.please help.