Hi,
Looking to have a sheet with three columns: Num(four digits), Start Date(Date+Time), End Date(Date+Time), populate a calendar on a seperate sheet.
Sample Data
Ideally I would like to have a sheet with the raw data and then on a separate sheet a calendar with big boxes, the "Num" in the corresponding Start and End dates with a coloured line between the two.
Num Start Date End Date 4123 11/24/2014 8:00 AM 12/5/2014 8:00 PM
What is the best way to go about creating this?
Everything I find on google is for a drop down date picker calendar, not how to actually make a calendar using the cells and insert data and formatting into them.
Thanks,
Alain!
Bookmarks