I am looking for some advice on creating a calender in excel that will read text dates in a spreadsheet and then transpose them into a calender. For example corporate has provided a list of 200+ employees by name and the corresponding vacation request days (see below for format). I would like for another spreadsheet in another tab to apply those dates into a calender and then have a conditional format for overlapping dates to change color.
<colgroup><col style="width: 192pt; mso-width-source: userset; mso-width-alt: 9362;" width="256"> <col style="width: 46pt; mso-width-source: userset; mso-width-alt: 2230;" width="61"> <col style="width: 122pt; mso-width-source: userset; mso-width-alt: 5924;" width="162"> <col style="width: 76pt; mso-width-source: userset; mso-width-alt: 3693;" width="101"> <col style="width: 71pt; mso-width-source: userset; mso-width-alt: 3437;" width="94"> <col style="width: 77pt; mso-width-source: userset; mso-width-alt: 3766;" width="103"> <col style="width: 83pt; mso-width-source: userset; mso-width-alt: 4059;" width="111"> <tbody>
</tbody>
NAME (LAST,FIRST_MI) | EMP ID | LOCATION | TDY LOCATION | STATUS | R&R DEPART (D/MM/YR) | R&R RETURN (D/MM/YR) |
Snuffy, Joe | 25-Nov-13 | 15-Dec-13 |
<colgroup><col style="width: 192pt; mso-width-source: userset; mso-width-alt: 9362;" width="256"> <col style="width: 46pt; mso-width-source: userset; mso-width-alt: 2230;" width="61"> <col style="width: 122pt; mso-width-source: userset; mso-width-alt: 5924;" width="162"> <col style="width: 76pt; mso-width-source: userset; mso-width-alt: 3693;" width="101"> <col style="width: 71pt; mso-width-source: userset; mso-width-alt: 3437;" width="94"> <col style="width: 77pt; mso-width-source: userset; mso-width-alt: 3766;" width="103"> <col style="width: 83pt; mso-width-source: userset; mso-width-alt: 4059;" width="111"> <tbody>
</tbody>