Spreadsheet: 220108d1363064634-how-do-i-make-a-date-in-a-drop-down-menu-populat-other-cells-with-folloeing-days-pto-cheat-sheet-excel-forum-ans
Sheet: PTO CALENDAR (Week 5-8)

Name: |  |  |  |  | PTO Code |  |  | PTO Code |  |  | Pto Code |  |  | PTO Code |  |  | PTO Code |  |  | PTO Code |  |  | PTO Code |  |  | Week 5 |  | 1 | 19 Jan-01 Feb 13
Employee ID: |  |  |  | Pay                  Code |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 Feb-15 Feb 13
Pay Period: |  | 30 Mar-12 Apr 13 |  |  | Sat: |  |  | Sun: |  |  | Mon: |  |  | Tue: |  |  | Wed: |  |  | Thu: |  |  | Fri: |  |  | PTO |  | 3 | 16 Feb-1 [NAME] 13
 |  | Project |  |  | 2013-03-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total |  | 4 | 2 Mar-15 Mar 13
1 | [PHONE].1   Labor |  |  | R | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 5 | 16 [NAME] 13
2 | [PHONE].2   [NAME] |  |  | JDP | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 6 | 30 Mar-12 Apr 13
3 | [PHONE].3   Post Differential |  |  | JPD | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 7 | 13 Apr-26 Apr 13
4 | [PHONE].4   PTO Post Differential |  |  | JPD | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 8 | 27 Apr-10 May 13
5 | 600000.001   Engility Paid Time Off |  |  | PTO | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 9 | 11 May-24 May 13
6 | 600000.002   Engility Holiday |  |  | HOL | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 10 | 25 May-7 [NAME]
7 | 600000.003   Engility Floating Holiday |  |  | FLT | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 11 | [NAME] 13
8 | 600000.008  Engility Leave w/o Pay |  |  | LWP | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 12 | 22 Jun-5 Jul 13
 |  |  |  | Pay                  Code |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 6 |  | 13 | 6 Jul-19 Jul 13
Pay Period: |  |  |  |  | Sat: |  |  | Sun: |  |  | Mon: |  |  | Tue: |  |  | Wed: |  |  | Thu: |  |  | Fri: |  |  | PTO |  | 14 | 20 Jul-2 Aug 13
 |  | Project |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total |  | 15 | 3 Aug-16 Aug 13
1 | [PHONE].1   Labor |  |  | R | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 16 | 17 Aug-30 Aug 13
2 | [PHONE].2   [NAME] |  |  | JDP | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 17 | 31 Aug-13 Sep 13
3 | [PHONE].3   Post Differential |  |  | JPD | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 18 | 14 Sep-27 Sep 13
4 | [PHONE].4   PTO Post Differential |  |  | JPD | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  | BRV-3 | 19 | 28 Sep-11 Oct 13
5 | 600000.001   Engility Paid Time Off |  |  | PTO | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 20 | 12 Oct-25 Oct 13
6 | 600000.002   Engility Holiday |  |  | HOL | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 21 | 26 Oct-8 Nov 13
7 | 600000.003   Engility Floating Holiday |  |  | FLT | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 22 | 9 Nov-22 Nov 13
8 | 600000.008  Engility Leave w/o Pay |  |  | LWP | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 23 | 23 Nov-6 Dec 13
 |  |  |  | Pay                  Code |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 7 |  | 24 | 7 Dec-20 Dec 13
Pay Period: |  | 13 Apr-26 Apr 13 |  |  | Sat: |  |  | Sun: |  |  | Mon: |  |  | Tue: |  |  | Wed: |  |  | Thu: |  |  | Fri: |  |  | PTO |  | 25 | 21 Dec-3 Jan 14
 |  | Project |  |  | 2013-04-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total |  | 26
1 | [PHONE].1   Labor |  |  | R | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 27
2 | [PHONE].2   [NAME] |  |  | JDP | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 28
3 | [PHONE].3   Post Differential |  |  | JPD | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 29
4 | [PHONE].4   PTO Post Differential |  |  | JPD | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 30
5 | 600000.001   Engility Paid Time Off |  |  | PTO | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  | 31
6 | 600000.002   Engility Holiday |  |  | HOL | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
7 | 600000.003   Engility Floating Holiday |  |  | FLT | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
8 | 600000.008  Engility Leave w/o Pay |  |  | LWP | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  |  |  | Pay                  Code |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 8
Pay Period: |  |  |  |  | Sat: |  |  | Sun: |  |  | Mon: |  |  | Tue: |  |  | Wed: |  |  | Thu: |  |  | Fri: |  |  | PTO
 |  | Project |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
1 | [PHONE].1   Labor |  |  | R | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
2 | [PHONE].2   [NAME] |  |  | JDP | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
3 | [PHONE].3   Post Differential |  |  | JPD | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
4 | [PHONE].4   PTO Post Differential |  |  | JPD | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
5 | 600000.001   Engility Paid Time Off |  |  | PTO | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
6 | 600000.002   Engility Holiday |  |  | HOL | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
7 | 600000.003   Engility Floating Holiday |  |  | FLT | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
8 | 600000.008  Engility Leave w/o Pay |  |  | LWP | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0