vba - Excel Average of Data Between a Date -

i need perform excel task of doing [(cash + card + check) - part cost] , finding average between set of dates receive average profit given amount of time. should not difficult, on paper formula easy , believe dates in excel numerical in value, cannot seem figure out. here's image better aid in understanding:

as can see on left "date" column located @ column a. , bit right this:

all need is, within date range, add cash + card + check , subtract total part cost column. issue not being able add of sums of columns , subtract them part cost, issue coming formula finds average based on number of rows between set of dates, decided week start , week end input box on column q.

i know need along lines of =if(a:a >= q1 , a:a <= q2, average((k:k + m:m + n:n)-h:h),0). if understand i'm trying at, please assist me.

recap: columns k, l, , m within input date range need added , subtracted column h values within date range, , need average of them. average of (k + l + m) - h within specified date range.

for example provided, because 7/14/2015 selected date, return average based on 1 day.

i'm sure there more elegant way of doing this. adjust ranges needed , formula needs entered control + shift + enter.

(sum(if($a$5:$a$9>=$q$1,if($a$5:$a$9<=$q$4,$l$5:$n$9)))-sum(if($a$5:$a$9>=$q$1,if($a$5:$a$9<=$q$4,$h$5:$h$9))))/(max(if($k$5:$k$9<>"",if($a$5:$a$9<=$q$4,$a$5:$a$9)))-min(if($k$5:$k$9<>"",if($a$5:$a$9>=$q$1,$a$5:$a$9)))+1) 

let me know if desired result.