auto-populating event excel calendar

Hi-

I have a spreadsheet that I'm stuck on. Here is what i need it to do auto -populate the calander with data based on a start date and end date

Example

Start Date

9/17/2012

End Date

9/21/2012

and pull that info over to the calander on each date

see attached and please let mek now if anyone has any sugestions or could help me get this working correctly.

Currently it pulls only the start date

Thanks in advance.

Hi,

Your calendar will work for me, but the year only goes up to 2013 ... not sure how to modify the code in the cell to increase the year?

I'd also like to add a 3rd piece of data to the day, wondering how to do that.

any input is greatly appreciated!

:-) joan

joanmariethomas @ yahoo.com