How to Pivot An Attendance table based on date

Question

Dear friends,

 

I need to use pivot table in sql server to generate attendance and column would be genrated based on date,

 

procedure code and Attendance format are attached as WinRar folder,

someone please help.