Small Function To Return Date Range

Hi Experts,

I have been stumped for a while on how to get my formula to show the specified rows where the condition is a range

I work for a trucking company where each load (from destination to origin) is recorded on a master sheet. Using the information from the master sheet I am trying to create a section that summarizes each drivers productivity for the current pay period.

the drivers get payed every 14 days.

I have a formula that the user enters a [Driver Name], and a [Date].

The formula then return the rows that match those two criteria.


I would like to have a user just select the Driver and Date and it will also return the previous 14 days

Here's my working formula for just 1 day

Please Login or Register  to view this content.

The code in blue shows what I need to modify to show the Date Range ($E$3-14 to $E$3)

I have tried to use an AND to add conditions to the IF statement....

Please Login or Register  to view this content.

But I haven't had any luck. This could be something simple that I'm just missing.

Here's the worksheet. The sheet with the formula is "Driver Hours"
December Template Test 12-17.xlsx

Any help is greatly appreciated.

Thank you!

my mistake. I just changed it to blue if that makes it more visible

awesome! thank you very much.

Just to pick your brain for a second, is the IF statement multiplying those three results together then seeing if they equal (1) for the conditional?