You can use following formulas:
to get unique dates if you have O365:
=UNIQUE(A2:A14)
or in pre O365 use array formula:
=IFERROR(INDEX($A$1:$A$14,MATCH(1,--(COUNTIF($D$1:D1,$A$1:$A$14)=0),0)),"")
to get OnTime/Late value use
=IFERROR(IF(COUNTIFS($A$2:$A$14,D2,$B$2:$B$14,"Late")/D2,"Late","On Time"),"")
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…