The have created the following formula that counts a text quote from a column in another dynamically changing sheet.

=COUNTIF(OFFSET(Sheet1!$F$2,0,0,COUNTA(Sheet1!F:F),1),"Missing Data").

On the sheet that shows the found values (Sheet 2) I also want to add a Start Date in a field and an End Date in a field so the found values will only show between a specific date range.

I have a date range in column E on Sheet 1.


Where and how do I specify this ?

Thanks in advance