I am currently creating a holiday planner for all my employees on Excel 2010. I also want to create a separate cell for each day that shows how many people are available according to their skill set. E.g. I have 4 people that can sign certain documents and I need to know how many are in each working day. The planner is set up so that if the employee is away fro any reason the cell for that day will contain a letter and be highlighted in a colour, if the employee is in work, the box stays blank.
Any ideas on a formula to show the information needed above?