% of staff on annual leave

I am trying to create an annual leave calender with a cell at the bottom that states the percentage of staff on annual leave per day as we cannot have more than 20% staff off at one time. ex - Monday - 4 people off from a staff of 30 people new to excel so any suggestions how to do this would be good