MARCO VBA Pivot table referencing

Hello,

Hello! I'm working on an assignment and I'm a little stuck. I'd like it to be in VBA so I can run a macro when there are more serial numbers and dates.

There are 2 pivot tables. The first pivot table shows the error dates and how many error dates are created per a day pertaining to each serial number.
The second pivot table show the review dates and how many reviews were held per a date for each serial number.

I need a formula that will allow me to fill out column R and Column S. I need to find the sum of the count of errors in the First pivot table "Error_Count" per each date created per each Serial Number in the pivot table according the range of Dates in the Sum_Errors table and output the sum in the table.

For instance, R2 should be the sum of Count of Error_Dates (found in Column E) between the dates listed in P2 and O2 (2/11/20 - 3/11/20). The date won't always match but it has to be in-between the date range.
S2 should be the sum of Count of Error_Dates between the dates listed in O2 and Q2 (3/11/20-4/11/20). Both R2 and S2 refer to serial number in M2.

All the tables will have many more lines and dates. So, I'm trying very hard to think of some code that will help me count the errors between dates.

Thank you!!! I'd really appreciate the help.

That's basically what I had already. Just not specific enough, but thank you very much!

Hi Keebellah,

I've attached it again. Hopefully it works!

I'm trying to find the sum of the errors 1 month before the serial number's first review date and 1 month after the serial number's first review date. GETPIVOTDATA and INDIREC could work, but after looking it up I am so confused to how to even begin it. Not sure how I can have it work for each serial number?

Thank you Rorya for the help! I do have a question is the Error_Date referring to the table name or the column header?
=SUM(IFERROR(GETPIVOTDATA("Error_Date",$D$1,"Serial_Number",2195550432,"Error_Date",ROW(INDIRECT(P2&":"&O2))),0))