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 1-4)

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