Extract Year for Other Formula

Hi Everyone!,

I want to be able to extract the year(s) that would be input into our "Enter Date Range" category (F4 and J4) and include them into a formula within each month cell that will display how many units were purchased during that month and within the years desired; I would normaly just have a desired year category here, but there are other formulas (S8-F24) that needs a month and date as well. I have an example of the SUMIFS() equation (D11) that will tally up our quantity, but I do not know how to extract the possible different years from a month/day/year format and then include them into my date range criteria here in cell D11. I was thinking that having a static month/date format within each month column along with a variable year that would be linked to the dates entered would work: 1/1/(Variable) to 1/31/(Variable). Of course I cannot figure out how to accomplish this . All data is under the "Data Input" tab. I've set some data extend up to date 8/8/2016. The desired formulas would be under the "Monthly Summary" tab.

Conditions:

• The named range "PackagePurchased" need to match the particular package listed in column A

E.g. Pilates Class Single would be considered an individual packagepurchased.

• The named range "Date" will reflect the date data in our data input page. Again, the infromation pulled must be within the date year range given and reflect only units purchased during the respected month.

• The information we are summing is under the named range "Quantity"

A BiG preemptive Thank You everyone

- Penguin