Index Match tough formulas

[baker_89]

I have some terminology that may be confusing but I hope you can make sense of it.

I have a table on sheet2 named Table1 with

B2 is a drop down list that changes the pan type to be shown which all formulas refer to for searching
B6 I want to show the latest date the word "Glazed" appears in table col F
C6 same just the word "Straightened"
D6 same just the word "Cleaned"

B9 I have a formula already for this
C9 I want to show the total number of time the word "Glazed" shows up in table col F
D9 I want to search by the latest date the pan has but show table col J (col J looks like this, "3309 ea") just need the digits

B13 the same row as C6 but show table col K value
C13 Average time between dates that have text "glazed" in months is fine if not days
D13 would be the average time period between multiplied by the last cost for the remainder average cycle times left in the a rolling 12 month period (this is to show as time period between cycles shortens the life of the pan is reaching its limit) or Would it be cost effective to continue re-glazing or purchase new

SHEET1​

	A	B	C	D	E
1		Pan Type
2		Reg
3
4
5		Last Glazed On	Last Straightened	Last Cleaned
6		10/31/2018
7
8		Pan Age	# of Glaze Cycles	Last Pan Count
9		1/1/2011
10		7 Years 10 months
11
12		Last Glazing Cost	Avg Life of Glaze	Exp Yearly Cost
13
14
15

<colgroup style="border-collapse: collapse; width: auto;"><col style="border-collapse: collapse; width: auto;"><col style="border-collapse: collapse; width: auto;" span="3"><col style="border-collapse: collapse; width: auto;"></colgroup><tbody style="border-collapse: collapse; width: auto;">
</tbody>

SHEET2 TABLE HEADINGS​

A	B	C	D	E	F	G	H	I	J	K
Purchase Order ID	Purchase Order Item	Supplier #	Supplier	Pan Type	Request Type	Purchase Order Creation Date	Net Price	Price Unit	Ordered Quantity	Ordered Net Value/Limit

<colgroup style="border-collapse: collapse; width: auto;"><col style="border-collapse: collapse; width: auto;" span="2"><col style="border-collapse: collapse; width: auto;"><col style="border-collapse: collapse; width: auto;"><col style="border-collapse: collapse; width: auto;"><col style="border-collapse: collapse; width: auto;"><col style="border-collapse: collapse; width: auto;"><col style="border-collapse: collapse; width: auto;" span="2"><col style="border-collapse: collapse; width: auto;"><col style="border-collapse: collapse; width: auto;"></colgroup><tbody style="border-collapse: collapse; width: auto;">
</tbody>

 

[baker_89]

I've made headway with B6:D6 with this formula, =MAX(IF((Table1[Pan Type]=$B$3)*(Table1[Request Type]=B6),Table1[Purchase Order Creation Date]))

But now I need to finish the lower half, I think I am on the right track but I cannot get the last pan count and cost to work yet. When I do it just shows the largest value in the list instead of the most recent.

I still don't know where to start on the average time between dates. (preferably in days)