Spreadsheet: 220756d1363259114-how-do-i-populat-a-date-from-one-spreadsheet-to-another-from-a-drop-down-with-a-time-code-pto-cheat-sheet-excel-forum-1-ans
Sheet: PTO CALENDAR (Week 1-4)

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