Spreadsheet: 699349d1602554735-trying-to-return-a-large-range-of-vlookup-based-on-dates-new-budget-sheet
Sheet: PP Calendar 2020

2020 | Pay Period | Pay Month | Pay Day | Pay Period | Est. Amount | Actual NET | Estimated Pay Description | Actual Pay Description | Overtime to date with est | Overtime
Next pay day: | PP 1 | 1 | 14 | 12/22 - 1/4 |  | 4861.14 | 2 Sun + 2 OT + .1 OT + 33.10 of ND + 3 Holidays |  |  | 16
Next pay day: | PP 2 | 1 | 28 | 1/5 - 1/18 |  | 3837.2 | 2 Sun + 1 OT + 38.22 Hours of ND |  |  | 8
Next pay day: | PP 3 | 2 | 11 | 1/19 - 2/1 |  | 3834.13 | 1 Sun + 2 OT + 33.05 Hours of ND |  |  | 16 | Holiday
Next pay day: | PP 4 | 2 | 25 | Feb 2 - 15 |  | 3606.7 | 1 Holiday + 1 OT + 32.47 Hours of ND |  |  | 8 | 2 Holiday
Next pay day: | PP 5 | 3 | 10 | Feb 16 - 29 | 2720 | 2865.43 | 25.3 Hours of ND |  |  | 0
Next pay day: | PP 6 | 3 | 24 | [NAME] | 3650 | 3417.35 | 1 Sun + 1 OT + 14.3 Hours of ND |  |  | 8
Next pay day: | PP 7 | 4 | 7 | Mar 15 - 28 | 3650 | 3365.17 | 1 OT + 21.25 of ND |  |  | 16
Next pay day: | PP 8 | 4 | 21 | [NAME] 11 | 2950 | 3109.49 | 7.1 Hours of Sun + 6 Hours of ND + 0.27 of OT |  | 72 | 8
Next pay day: | PP 9 | 5 | 5 | Apr 12 - 25 | 3100 | 3261.4 | 1 Sun + 50.3 Hours of ND
Next pay day: | PP 10 | 5 | 19 | Apr 26 - May 9 | 3100 | 3078.12 | 22.3 Hours of ND
Next pay day: | PP 11 | 6 | 2 | May 10 - 23 | 3149.73 | 3149.73 | 1.3 Hours of Sun + 37.3 Hours of ND
Next pay day: | PP 12 | 6 | 16 | May 24 - Jun 6 | 1527.99 | 1527.99 | 37.3 Hours of ND
Next pay day: | PP 13 | 6 | 30 | [NAME] | 3200 | 2808.83 | .1 of OT
Next pay day: | PP 14 | 7 | 14 | Jun 21 - Jul 4 | 3132.26 | 3396.68 | 1 Sun + 24 Hours of ND + 1 Holiday |  | 0.1 / 9.88
Next pay day: | PP 15 | 7 | 28 | Jul 5 - 18 | 2936.93 | 3172.22 | 2 Sun + 54.5 Hours of ND |  | .2 / 30.76
Next pay day: | PP 16 | 8 | 11 | Jul 19 - Aug 1 | 3097.11 | 3097.11 | 6.5 Sun + 46.5 Hours of ND
Next pay day: | PP 17 | 8 | 25 | Aug 2 - 15 | 3147.34 | 3185.45 | 1 Sun + 70.5 Hours of ND
Next pay day: | PP 18 | 9 | 8 | Aug 16 - 29 | 2973.59 | 3099.61 | 1 Sun + 40 hours of ND | 8 Sun + 46.3 ND + .2 OT | 0.2 / 30.76
Next pay day: | PP 19 | 9 | 22 | Aug 30 - Sep 12 | 3095 | 2991.61 | 64 Hours of ND | 1.5 Sun 37.5 ND + .1 OT | 0.1 / 15.07
Next pay day: | PP 20 | 10 | 6 | Sep 13 - Sep 26 | 3108.42 | 3195.32 | 2 Sun + 49 Hours of ND | 16.2 Sun + 46.4 ND + .34 OT | 0.34 / 52.23
Next pay day: | PP 21 | 10 | 20 | Sep 27 - Oct 10 | 3001.89 | 0 | 6.5 Sun + 49.5 Hours of ND
Next pay day: | PP 22 | 11 | 3 | Oct 11 - 24 | 3452.95 | 0 | 1 Sun + 1 Holiday + 70.5 ND
Next pay day: | PP 23 | 11 | 17 | Oct 25 - Nov 7 | 3102.46 | 0 | 40 Hours of ND
Next pay day: | PP 24 | 12 | 1 | Nov 8 - 21 | 3330.54 | 0 | 57.5 Hours of ND + 1 Holiday
Next pay day: | PP 25 | 12 | 15 | Nov 22 - Dec 5 | 3084.94 | 0 | 1 Sun + 64 Hours of ND
Next pay day: | PP 26 | 12 | 29 | Dec 6 - Dec 19 | 2973.59 | 0 | 1 Sun + 40 Hours of ND
Next pay day: | PP 1 | 2020-01-12 00:00:00 |  | Dec 20 - Jan 2 | 3447.86 | $ - | 1 Sun + 72 Hours of ND + 1 Holiday
Next pay day: | PP 2 | 2020-01-26 00:00:00 |  | Jan 3 - 16 | 3131.54 | $ - | 14.5 Sun + 46.5 ND
Next pay day: | PP 3 | 2020-02-09 00:00:00 |  | Jan 17 - 30 | 3095 | $ - | 64 Hours of ND
Next pay day: | PP 4 | 2020-02-23 00:00:00 |  | Jan 31 - Feb 13 | 3084.94 | $ - | 1 Sun + 64 Hours ND
Next pay day: | PP 5 | 2020-03-09 00:00:00 |  | Feb 14 - 27 | 2973.59 | $ - | 1 Sun + 40 Hours of ND
Next pay day: | PP 6 | 2020-03-23 00:00:00 |  | Feb 28 - Mar 13 | 3185 | $ - | 1 Sun + 72 Hours of ND
Next pay day: | PP 7 | 2020-04-06 00:00:00 |  | [NAME] |  | $ -
Next pay day: | PP 8 | 2020-04-20 00:00:00 |  | Mar 28 - Apr 10 |  | 0
Next pay day: | PP 9 | 2020-05-04 00:00:00 |  | Apr 11 - 24 |  | 0
Next pay day: | PP 10 | 2020-05-18 00:00:00 |  | Apr 25 - May 8 |  | 0
Next pay day: | PP 11 | 2020-06-01 00:00:00 |  | May 9 - 22 |  | 0
Next pay day: | PP 12 | 2020-06-15 00:00:00 |  | May 23 - Jun 5 |  | 0
Next pay day: | PP 13 | 2020-06-29 00:00:00 |  | [NAME] |  | 0
Next pay day: | PP 14 | 2020-07-13 00:00:00 |  | Jun 20 - Jul 3 |  | 0
Next pay day: | PP 15 | 2020-07-27 00:00:00 |  | [NAME] |  | 0
Next pay day: | PP 16 | 2020-08-10 00:00:00 |  | Jul 18 - 31 |  | 0
Next pay day: | PP 17 | 2020-08-24 00:00:00 |  | Aug 1 - 14 |  | 0
Next pay day: | PP 18 | 2020-09-07 00:00:00 |  | Aug 15 - 28 |  | 0
Next pay day: | PP 19 | 2020-09-21 00:00:00 |  | Aug 29 - Sep 5 |  | 0
Next pay day: | PP 20 | 2020-10-05 00:00:00 |  | Sep 6 - 19 |  | 0
Next pay day: | PP 21 | 2020-10-19 00:00:00 |  | Sep 20 - Oct 2 |  | 0
Next pay day: | PP 22 | 2020-11-02 00:00:00 |  | Oct 3 - 16 |  | 0
Next pay day: | PP 23 | 2020-11-16 00:00:00 |  | Oct 17 - 30 |  | 0
Next pay day: | PP 24 | 2020-11-30 00:00:00 |  | Oct 31 - Nov 13 |  | 0
Next pay day: | PP 25 | 2020-12-14 00:00:00 |  | Nov 14 - 27 |  | 0
Next pay day: | PP 26 | 2020-12-28 00:00:00 |  | Nov 28 - Dec 11 |  | 0
 |  |  |  | Dec 20 - Jan 2