How do I count the total of repeating day that staff abset on the following
month?

example : From 1 to 30 of every month
Mon Tue Wed Thu Fri Sat Sun Mon Tue We Thu Fri Sat
Sun Mon & etc
staff a 1 1
1
staff b 1 1 1
1 1
staff c 1 1
1 1

Result shall be at following:

Mon Tues Wed Thu Fri Sat Sun
Staff a 1 1 1
Staff b 1 2 1

What's your recommended formula to the above result?