Daily,Weekly,Monthly Report

Dear ExcelForum Users,

I need a little bit of help here on my project... I will try to explain as much as possible

I have an 8 Employees in Total

3 Employee on Early shift (C shift)
3 Employee on afternoon shift ( B shift)
2 Employee on Night Shift ( A Shift)

Each Users Processes items in numbers on a daily basis

what I need to see is that, How many ıtems Processed by each user on a daily basis (for yesterday) , Weekly basis (for 7 days Monday to Sunday) and Monthly basis between 01st and 30th days of AprilTest.xlsx for example)

Thanks in advance.

Ben