Could you please provide some sample data so it would be easy to provide solution
I have attached a sample workbook, I need the count of employees who are absent since 12th of october,
So emp ids that are showing Absent as data type for the 12th and 13th of October in continuity will fall under 2 days bucket as today is 14th Oct.
Similarly I need buckets of count of emp 3 to 5 days ...i.e emp that are absent for more than 3 to 5 days in continuity till today.
Seems like some issue I don't see any workbook attached copy paste the data if you are not able to attach the workbook