Hi All,

I need some help creating a multistep PTO calendar where I create a form that will input the data into rows and then transferred over to a calendar view. I have basic to moderate Excel experience and know this is a bit out of my league, but would like to learn how to do this.

Can someone please let me know how I should get started on this? I'd like to have a dropdown list of employee names and the start/end dates of when they're off.
We could skip this form step altogether, but it would be nice to have.

In short, I'd like to have data, or a list of PTO ranges to show up in a 12 month calendar view (that also archives/shows future years IE - 2014-2020)

Example would be:

Employee Start-Date End-Date

Employee Name Start Date End Date Type
Bob 8/1/2015 8/5/2015 PTO
Billy 8/2/2015 8/2/2015 Sick