If/And Nested Statement between dates

So I'm hoping that this is my last posting for this project. I received help yesterday to write an expression to count rows if the date was from the previous month and if the the row met the turnaround time. I'm looking to change this expression so that instead of looking at one date, it will look at a range of dates and if any fall during the previous month, I would like it to count it along with meeting the criteria that it meets our turnaround time. Here is my expression.

Please Login or Register  to view this content.

Just to clarify a few things, my first set of dates are in column D, the second set in E, and then my turnaround days are listed under F. Is there anything that I can do to look in those range of dates for the previous month and count those only if they also meet the criteria of meeting the turnaround time of less than 3 days?

why is the range D2:D2?

Try:

Please Login or Register  to view this content.

assuming range of rows is 2:100 and start/end dates to look for are in X2 and Y2 respectively.

Adjust as needed.

Try this one:

Please Login or Register  to view this content.