Example file is attached.

Example.xls

This is a very dirty semi-recreation of the file I'm talking about. I named the May 1 calendar box "name" so you can see what I mean. Unfortunately (obviously) even if you enter "May 3", it will enter the information on the calendar on May 1.

I need Excel to know which range to select from what the user chooses under "date".

Thanks again!