Need help to add a date range variable to a forumla

OK so first let me explain what we have here,
In column AB is where my receipt numbers are, this should be populated with something before being included in the calculation.

In F2 is where the currency is listed ex. CAD, AUD

C2 is on the page where the formula resides. It’s my results tab. C2 is the cell that the formula referrers to when checking which currency to sum up
.
E is the column where all the dollar values reside

Now what I’m looking to add to this formula is the following.
On the results tab, where C2 is I want to be able to input a “from” date and “to” date range. I want everything between equal to or between the date ranges to be calculated along with the rest of the variables. These dates are found in column AC.

I’ve attached a sample of the document I’m referring to.

Please Login or Register  to view this content.

yes, on the 2nd tab I have the field where I want to be able to enter the date range, the formula should be referring to this date range to return results.

Hope I'm not confusing the question? So yes I want to integrate this into the existing formula.

It works like a dream, thank you so much.