Hello folks,

I'm fairly new to excel and am having a couple of issues with a little project I'm working on. So there is this weird chart that I want to be able to paste into excel and pull certain info from, which is kind of difficult because the chart has a variable number of columns depending on the date requested. I've attached the chart to this post.

Basically it shows how many bookings for specifics dates were made at any given point in time. I want to be able to get a simple input/output system going where I can punch in the date I want to look from the perspective of and have it tell me how many bookings can be expected for upcoming dates. I've made a little sample below the chart to show what this would look like, and I've provided an example scenario. I just want to make it dynamic enough that I could put any date in there and it would feed me the info. Any help on this would be greatly appreciated!

Thanks!

P.S. using Excel 2010 on PC

Chart Sample.xlsx