Calendar Entries In Excel
 

Hi,
I'm trying to create a tool for my department where supervisors can enter
specific data into a spread sheet but then display in an actual calendar that
we can distribute to our staff.

I've tried messing around with some of the templates but am not having luck.

Right now I have 9 columns on one sheet for data entry.
Say I enter someone for a vacation day for May 1. I'd like to be able to
enter that in the one sheet, and have it auto-populate the calendar for May 1
saying "Bob-Vacation" or something to that effect.

Can anyone assist me?