Hello Friends,
Thanks in advance for your help.
Here is the problem, i need solution for this.
We have an excel file with Employee IDs, Names, Department, and dates as the Head points. With this file, we will plan for the employees weekly off and equal manpower distribution in our company.
So here is, All i want is, I need Summary of the Employee counts on that current day in a first sheet, and Employees roster data will be in second sheet. When the date changes, The counts should also captured based on dates.
I have enclosed the excel with data, Requesting you apply necessary formulas and help me.
Bookmarks