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!

Hi Shukla,

Thanks so much, that looks great! Just a couple questions though:

1) It looks like the first entry in the second column displays an incorrect value. I'm guessing something goes wonky cause there's nothing at 9:00AM on 2 Apr. Is there a way to address this?
2) And is there any possible way to eliminate duplicates?

At any rate, thanks a bunch!!