Graphing a large dataset

Hello,

I have a daily time series (1/1/2007 to 12/31/2007) and numerical data corresponding to each day. I want to be able to use some type of lookup formula (such as index or match) so I can choose any month and then a table of daily data will be displayed for that month.

I had a similar problem with an hourly dataset, which someone already helped me with. But when I tried to adjust the index and match formulas for my daily data, I got error messages.

If someone could please take a look at the attached sheet and tell me where I'm going wrong, it would be much appreciated!

Thanks!!

Daily Template.xlsx

Thank you Soren Larsen - your formula worked well.

Thank you also DiliPandey, but I didn't use the array formula because it was very complicated.

I have one more question. If I have the name of the month in one cell (ex: January), is there a formula I can use to return the month and year (January 2007)?

I've tried the datevalue function but that gives me January 1, 2007. I just want the month and year.

Thanks again!

Thank you!