Excel formula required - to only calculate between certain dates (from an access database)

I have an access database full of results from over 6 years.

I have an excel sheet that has a lot of formulas to analyse the data in the access database.

I would like a way of only calculating between certain dates or after certain dates. The date range FROM will be in Cell EV1 and TO will be in Cell EW1 -

There are some quite complex formulas - eg. countifs/countifs/counta etc.

See below - "YEARQUERY" is the data from the Accessdatabase. "DAYQUERY" is from a day I want to analyse.

=IFERROR(COUNTIFS(YEARQUERY[horse],DAYQUERY[@horse],YEARQUERY[pos],1)/COUNTIF(YEARQUERY[pos],1)/(COUNTIF(YEARQUERY[horse],DAYQUERY[@horse])/COUNTA(YEARQUERY[horse])),0)

There are other similar formulas using Averageifs/averageifs/averageifs

Another formula

=TRANSPOSE(FILTER(YEARQUERY[PRB2S],YEARQUERY[horse]=DAYQUERY[@horse]))

Get in touch if you can do this!