Rolling 12 month table from data range

Hi
I am trying to create a rolling 12 month graph by first building a table based upon date data contained within a named range.
The table will contain counts of the number of times a date from the given month appears. I am having trouble building the
formula to correctly select the month and year. I am working backwards in that in the last column will be this months data
and I want to be able to just -1 to go back one month and so on until I build the 12 month history.

I have attached the spreadsheet. Rows 22, 23 and 24 coloured in green is what I am trying to calculate.

Any assistance is greatly appreciated.

Cheers

just moving this post higher again

Hi DILIPandey

I have added the expected values and also for reference the month/year in row 21 (but this should automatically change each month)

Thanks

Hi DILIPandey

1. D22 - O22 needs to count the number of requests closed during the month indicated in D20-020. The cell in purple is the corresponding cell in the yearly data.
2. The Outstanding @ EOM D23 - O23 needs to count the number of requests open at the end of the month indicated in D20-O20

I have added notes to the bottom of the table to explain how I expect to calculate the totals.

I am just stuck on how to use the formula to count only the months and year and ignore the day.

Version d uploaded.

ThanksRequest Register V1d.xlsx

Rows 16,17and 18 are for the year selected in B9.
I want rows 21,22 and 23 to be rolling 12 months (ie go back 12 consecutive months.)

No I need to calculate the years total seperate to the rolling 12 months so the 2 calculations will be seperate.

Thanks

No I do not need the rolling 12 months summed up
D20 yes as this is the axis labels for my data.

thanks

rows 21,22 and 23 each column will detail the total requests that fall in the particular month (row 20). At the end of the columns (ie colum P) i do not want totals for cells D thru O