PLEASE HELP! Identify Dates of Missing Timesheets for Employees

I want to be able to identify the dates that employees did NOT complete timesheet (days when there is no timesheet data entry), and create a pivot table showing how many timesheets are missing for each employee, on which dates they did not provide a timesheet, and show the date of their most recent timesheet. I have attached a simple example of the data. Any help I can get would be appreciated - I'm not very advanced in excel and wish I could figure it out for myself, but this is time sensitive.

Thanks!