Vacation replacement - Knowing when there are to many replacement due on certain days

Hi AC,

we are using Airtable for employees to submit their vacation dates. They provide a start, as well as an end date of their vacation, so that we are able to accept or decline their inquiry. We have to replace every shift with another employee and can only do so untill a certain count. Lets say 10 replacements per day to keep every thing running.

i would love to find a smart solution, where Airtable already suggest a decline, because 10 relplacements where already accepted on that certain date.

How to i go from a tange between to dates to counts on a specific date?