Check a date range and return value based on the date range

**KeithCar** · 07-13-2015, 10:42 AM

hello, I really need help with this.
I have two sheets- the first one has an option to put in a date range as seen below:

Start Date End Date
14/07/2015 22/07/2015

in the second sheet i have a yearly schedule for all my staff, but the way i have it laid out is the number of staff that will be in the office in the first column and the date will be in the second column, like below:

staffed Date
20 13/07/2015
21 14/07/2015
22 15/07/2015
20 16/07/2015
19 17/07/2015

What i need the formula to do is check the date range in the first sheet against the numbers and dates in the second one and return a value.

Example- i put a start and end date of my holidays into it, it checks the sheet and if i have less than 20 staffed on any of the dates specified it will say rejected. put if there is 20 or more staffed each day it will say approved.

I have added screen shots in the hope that i helps you to understand what i mean

**oeldere** · 07-13-2015, 10:44 AM

You get better help on your question if you add a small excel file, without confidential information.

Please also add manualy the expected result in your file.

**KeithCar** · 07-13-2015, 10:56 AM

As requested i have added a fake copy of the spread sheet, you will notice that on the dashboard tab person 1 is looking for 14/07/2015 until the 22/07/2015 as holidays and in cell H2 it states approved. so basically when there is 20 or more people staffed for week it will return approved and if not it will return rejected.