Dynamic Range with user input

I have a list of months in excel with the MMM-YY format.

I'm wanting to create a dynamic range that's range is only that of the month the user inputs plus the previous 3 months (so 4 months all together).

I've attached a sheet showing my list of dates along with the user.

Any help would be great

Here is one way to do it - see attached.

Also added logic to show a blank cell if the user input is first on the list (try user input for JAN2011, FEB2011, MAR2011, APR2011; you'll see the pink range populate).

This will only work if your input is the first of the month (or use the MAR2011 style of input displayed above). I could enhance it to match any date if necessary.

Good luck!

~Coleman

The range will eventually be used as a graphs x-axis if that changes anything?

I did get something almost to work with using OFFSET but it didn't like when the top one on the list was chosen as it was trying to offset up and there was nowhere to go