I am working on a project to benefit a non-profit daycare - they would like an easy way to schedule clients/see how many children are in the facility at a given time.

I have a table set up where staff can enter the client's name, number of children, and children's arrival/departure times. For each client, I would like the number of children they will be leaving at the center applied on a corresponding table based on the arrival/departure time.

For example: If client 1 has 2 children and will be leaving them from 8 am to 12 pm, on the corresponding table( to the left in my spreadsheet), under the "Client 1" column, I would like the number 2 to auto-populate from 8 am to 12 pm.

I have tried a number of formulas - including VLOOKUP and IF(AND) and can't seem to get the combination just right. Any help would be greatly appreciated!!!

Daycare Help.xlsx