populate events calendar from inputs

Hello,

First post here! Long time lurker... wanted to say thanks to everyone for all your contributions, this website is very helpful, especially for excel novices such as myself!

So I am trying to create an events calendar which is populated by inputting date/times/descriptions.

I'm hoping each inputted description is placed in corresponding cell based on date/time. The main problem I think I would have is getting all the formatting automated. Also, the event could be 1 day or 5 days, and I'm not sure how to address that in the output.

Not sure how helpful it would be, but I've attached a file to give an idea what I was looking for. Any help would be greatly appreciated!