Excel Event Calendar Index/Match Issue

I have a multi-event calendar that allows multi-date events as well, attached, that has a default month-view.

I really like the way you can type in the month and date and have it change, that's pretty neat! I'm going to mull over your formulas and attempt to make it work on my calendar.

Edit:

Okay ... So your formula is quite impressive and I am at a loss. I noticed after poking it for a while that the formula stays consistent as you go down the row. B5 is the same as B13 for instance yet it posts two different results. I don't see any place where it grabs the date to do so except for maybe this:

Please Login or Register  to view this content.

Any information would be great

The way that the formula works is basically on four row blocks - that is why the first row of dates is row 4 - for rows 5, 6, and 7, that formula will return the value from row 4:

On row 5, INT(ROW()/4)*4 becomes INT(1.25)*4 becomes 1*4 becomes 4
On row 6, INT(ROW()/4)*4 becomes INT(1.5)*4 becomes 1*4 becomes 4
On row 7, INT(ROW()/4)*4 becomes INT(1.75)*4 becomes 1*4 becomes 4

which is the date above the three rows used to display the data for that day. IF you wanted to increase the number of possible returns to, say, 6, then you would need to insert two rows above row 4, making it row 6, and insert two rows within the data areas, and change that part of the formula to

B:B,INT(ROW()/6)*6