Spreadsheet: 178886d1346946611-how-to-write-a-formula-to-return-a-value-based-on-a-set-date-every-month-payroll-late
Sheet: Student Worker Pay

Name | Dept | Title | Timesheet Start Date | Timesheet End Date | Valid | Rate | Hours | Days | Pay | Due  Date | Date  Submitted | Late
Aceves, Teresa | Horticulture |  | 2012-07-02 00:00:00 | 2012-07-31 00:00:00 |  |  | 136 | 17 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Aceves, Teresa | Horticulture |  | 2012-08-01 00:00:00 | 2012-08-30 00:00:00 |  |  | 75 | 15 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Acosta, [NAME] | Horticulture |  | 2012-07-05 00:00:00 | 2012-07-27 00:00:00 |  |  | 31.5 | 6 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Acosta, [NAME] | Horticulture |  | 2012-08-21 00:00:00 | 2012-08-31 00:00:00 |  |  | 35.5 | 6 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Andrzejewski, Britnee | Animal |  | 2012-07-10 00:00:00 | 2012-07-31 00:00:00 |  |  | 37 | 16 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Andrzejewski, Britnee | Animal |  | 2012-08-02 00:00:00 | 2012-08-21 00:00:00 |  |  | 38 | 6 |  | 2012-08-31 00:00:00 | 2012-08-30 00:00:00
Antillon, [NAME] | Physics Engineering |  | 2012-08-21 00:00:00 | 2012-08-27 00:00:00 |  |  | 5.5 | 3 |  | 2012-08-31 00:00:00 | 2012-08-31 00:00:00
Balsiger, Joel | Horticulture |  | 2012-07-18 00:00:00 | 2012-07-30 00:00:00 |  |  | 34 | 5 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Balsiger, Joel | Horticulture |  | 2012-08-01 00:00:00 | 2012-08-30 00:00:00 |  |  | 63 | 12 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Castaneda, [NAME] | Horticulture |  | 2012-07-02 00:00:00 | 2012-07-30 00:00:00 |  |  | 120 | 15 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Castaneda, [NAME] | Horticulture |  | 2012-08-01 00:00:00 | 2012-08-15 00:00:00 |  |  | 80 | 10 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
[NAME], Shannon | Animal |  | 2012-08-01 00:00:00 | 2012-08-30 00:00:00 |  |  | 86 | 18 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Eccles, Samantha | Animal |  | 2012-07-02 00:00:00 | 2012-07-31 00:00:00 |  |  | 87 | 18 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Eccles, Samantha | Animal |  | 2012-08-01 00:00:00 | 2012-08-31 00:00:00 |  |  | 114 | 19 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Espinosa, Stephen | Physics Engineering |  | 2012-08-21 00:00:00 | 2012-08-31 00:00:00 |  |  | 14 | 5 |  | 2012-08-31 00:00:00 | 2012-08-31 00:00:00
[NAME], Adrian | Horticulture |  | 2012-07-11 00:00:00 | 2012-07-31 00:00:00 |  |  | 86 | 11 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
[NAME], Adrian | Horticulture |  | 2012-08-01 00:00:00 | 2012-08-31 00:00:00 |  |  | 98 | 16 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
[NAME], [NAME] | NSD |  | 2012-07-02 00:00:00 | 2012-07-31 00:00:00 |  |  | 67 | 17 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
[NAME], [NAME] | NSD |  | 2012-08-01 00:00:00 | 2012-08-31 00:00:00 |  |  | 89 | 21 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
[NAME], [NAME] | Earth Sciences |  | 2012-07-06 00:00:00 | 2012-07-19 00:00:00 |  |  | 24 | 6 |  | 2012-07-31 00:00:00 | 2012-08-15 00:00:00
[NAME], [NAME] | Earth Sciences |  | 2012-08-02 00:00:00 | 2012-08-25 00:00:00 |  |  | 38 | 6 |  | 2012-08-31 00:00:00 | 2012-08-30 00:00:00
[NAME], [NAME] | Animal |  | 2012-07-06 00:00:00 | 2012-07-26 00:00:00 |  |  | 46 | 8 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
[NAME], [NAME] | Animal |  | 2012-08-08 00:00:00 | 2012-08-24 00:00:00 |  |  | 27 | 7 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
[NAME], [NAME] | Horticulture |  | 2012-07-02 00:00:00 | 2012-07-31 00:00:00 |  |  | 88.5 | 14 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
[NAME], [NAME] | Horticulture |  | 2012-08-01 00:00:00 | 2012-08-29 00:00:00 |  |  | 75.25 | 13 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Jordan, [NAME] | Horticulture |  | 2012-07-05 00:00:00 | 2012-07-31 00:00:00 |  |  | 72 | 15 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Jordan, [NAME] | Horticulture |  | 2012-08-01 00:00:00 | 2012-08-30 00:00:00 |  |  | 89 | 18 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Jordan, [NAME] | Horticulture |  | 2012-07-05 00:00:00 | 2012-07-31 00:00:00 |  |  | 72 | 15 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Jordan, [NAME] | Horticulture |  | 2012-08-01 00:00:00 | 2012-08-30 00:00:00 |  |  | 89 | 18 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
[NAME], [NAME] | Physics Engineering |  | 2012-08-01 00:00:00 | 2012-08-31 00:00:00 |  |  | 80 | 18 |  | 2012-08-31 00:00:00 | 2012-08-31 00:00:00
[NAME], [NAME] | Horticulture |  | 2012-07-02 00:00:00 | 2012-07-25 00:00:00 |  |  | 74 | 15 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
[NAME], [NAME] | Horticulture |  | 2012-08-01 00:00:00 | 2012-08-22 00:00:00 |  |  | 76 | 12 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
[NAME], [NAME] | RVT |  | 2012-08-27 00:00:00 | 2012-08-29 00:00:00 |  |  | 19 | 3 |  | 2012-08-31 00:00:00 | 2012-08-30 00:00:00
Lopez, Blanca | Animal |  | 2012-07-06 00:00:00 | 2012-07-27 00:00:00 |  |  | 27 | 6 |  | 2012-07-31 00:00:00 | 2012-08-02 00:00:00
Lopez, Blanca | Animal |  | 2012-08-07 00:00:00 | 2012-08-24 00:00:00 |  |  | 35.75 | 7 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Machaca, Patty | Horticulture |  | 2012-07-02 00:00:00 | 2012-07-31 00:00:00 |  |  | 92 | 14 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Machaca, Patty | Horticulture |  | 2012-08-01 00:00:00 | 2012-08-29 00:00:00 |  |  | 82.5 | 14 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Marquez, [NAME] | Earth Sciences | [NAME] | 2012-06-01 00:00:00 | 2012-06-29 00:00:00 |  | 8 | 56 | 14 |  | 2012-06-30 00:00:00 | 2012-07-30 00:00:00
Marquez, [NAME] | Earth Sciences |  | 2012-07-06 00:00:00 | 2012-07-28 00:00:00 |  |  | 39 | 8 |  | 2012-07-31 00:00:00 | 2012-07-30 00:00:00
Marquez, [NAME] | Earth Sciences |  | 2012-08-01 00:00:00 | 2012-08-22 00:00:00 |  |  | 50.5 | 10 |  | 2012-08-31 00:00:00 | 2012-08-31 00:00:00
Meraz, Stephen | Horticulture |  | 2012-07-02 00:00:00 | 2012-07-31 00:00:00 |  |  | 127 | 16 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Meraz, Stephen | Horticulture |  | 2012-08-01 00:00:00 | 2012-08-24 00:00:00 |  |  | 96 | 12 |  | 2012-08-31 00:00:00 | 2012-08-30 00:00:00
[NAME], [NAME] | Animal |  | 2012-07-03 00:00:00 | 2012-07-31 00:00:00 |  |  | 113 | 17 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
[NAME], [NAME] | Animal |  | 2012-08-01 00:00:00 | 2012-08-30 00:00:00 |  |  | 122 | 18 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Moore, [NAME] | Animal |  | 2012-07-02 00:00:00 | 2012-07-23 00:00:00 |  |  | 17 | 5 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Moore, [NAME] | Animal |  | 2012-08-06 00:00:00 | 2012-08-31 00:00:00 |  |  | 39 | 9 |  | 2012-08-31 00:00:00 | 2012-08-30 00:00:00
Mowery, Blair | Animal |  | 2012-08-27 00:00:00 | 2012-08-31 00:00:00 |  |  | 10 | 3 |  | 2012-08-31 00:00:00 | 2012-08-30 00:00:00
[NAME], Orlando | Animal |  | 2012-07-06 00:00:00 | 2012-07-25 00:00:00 |  |  | 31.5 | 5 |  | 2012-07-31 00:00:00 | 2012-08-02 00:00:00
[NAME], Orlando | Animal |  | 2012-08-01 00:00:00 | 2012-08-24 00:00:00 |  |  | 82 | 11 |  | 2012-08-31 00:00:00 | 2012-08-30 00:00:00
Pawlak, Mary | Horticulture |  | 2012-08-27 00:00:00 | 2012-08-30 00:00:00 |  |  | 25 | 4 |  | 2012-08-31 00:00:00 | 2012-08-30 00:00:00
Payne, [NAME] | Earth Sciences |  | 2012-07-02 00:00:00 | 2012-07-30 00:00:00 |  |  | 62 | 18 |  | 2012-07-31 00:00:00 | 2012-08-01 00:00:00
Porras, Victoria | Horticulture |  | 2012-07-02 00:00:00 | 2012-07-30 00:00:00 |  |  | 92.5 | 12 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Porras, Victoria | Horticulture |  | 2012-08-01 00:00:00 | 2012-08-30 00:00:00 |  |  | 102.5 | 14 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Powers, [NAME] | Earth Sciences |  | 2012-08-27 00:00:00 | 2012-08-29 00:00:00 |  |  | 10.5 | 3 |  | 2012-08-31 00:00:00 | 2012-09-04 00:00:00
[NAME], [NAME] | NSD |  | 2012-07-02 00:00:00 | 2012-07-31 00:00:00 |  |  | 79 | 17 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
[NAME], [NAME] | NSD |  | 2012-08-01 00:00:00 | 2012-08-30 00:00:00 |  |  | 49 | 12 |  | 2012-08-31 00:00:00 | 2012-08-30 00:00:00
[NAME], [NAME] | NSD |  | 2012-09-04 00:00:00 | 2012-09-06 00:00:00 |  |  | 7 | 2 |  | 2012-09-30 00:00:00 | 2012-08-30 00:00:00
Randall, [NAME] | Grants |  | 2012-07-02 00:00:00 | 2012-07-26 00:00:00 |  |  | 40 | 12 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Randall, [NAME] | Grants |  | 2012-08-01 00:00:00 | 2012-08-24 00:00:00 |  |  | 39.5 | 12 |  | 2012-08-31 00:00:00 | 2012-08-30 00:00:00
Redinger, [NAME] | Grants |  | 2012-07-02 00:00:00 | 2012-07-30 00:00:00 |  |  | 56.5 | 14 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Redinger, [NAME] | Grants |  | 2012-08-01 00:00:00 | 2012-08-24 00:00:00 |  |  | 55 | 15 |  | 2012-08-31 00:00:00 | 2012-08-30 00:00:00
Ruiz, Briana | NSD |  | 2012-07-02 00:00:00 | 2012-07-31 00:00:00 |  |  | 65.75 | 16 |  | 2012-07-31 00:00:00 | 2012-07-30 00:00:00
Ruiz, Briana | NSD |  | 2012-08-01 00:00:00 | 2012-08-31 00:00:00 |  |  | 40.25 | 12 |  | 2012-08-31 00:00:00 | 2012-08-31 00:00:00
Smith, Lindsey | Animal |  | 2012-07-02 00:00:00 | 2012-07-03 00:00:00 |  |  | 17 | 4 |  | 2012-07-31 00:00:00 | 2012-08-13 00:00:00
Smith, Lindsey | Animal |  | 2012-08-01 00:00:00 | 2012-08-30 00:00:00 |  |  | 57 | 17 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Solis, Robyn | Wildlife |  | 2012-07-07 00:00:00 | 2012-07-24 00:00:00 |  |  | 15 | 6 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
[NAME], [NAME] | Animal |  | 2012-07-09 00:00:00 | 2012-07-30 00:00:00 |  |  | 41 | 7 |  | 2012-07-31 00:00:00 | 2012-08-06 00:00:00
[NAME], [NAME] | Animal |  | 2012-08-01 00:00:00 | 2012-08-29 00:00:00 |  |  | 54 | 10 |  | 2012-08-31 00:00:00 | 2012-08-30 00:00:00
Tamillo, Blanca | Horticulture |  | 2012-07-02 00:00:00 | 2012-07-31 00:00:00 |  |  | 62 | 9 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Tamillo, Blanca | Horticulture |  | 2012-08-01 00:00:00 | 2012-08-22 00:00:00 |  |  | 57 | 9 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
[NAME], [NAME] | Math |  | 2012-07-02 00:00:00 | 2012-07-31 00:00:00 |  |  | 68 | 16 |  | 2012-07-31 00:00:00 | 2012-07-24 00:00:00
[NAME], [NAME] | Math |  | 2012-08-01 00:00:00 | 2012-08-02 00:00:00 |  |  | 8 | 2 |  | 2012-08-31 00:00:00 | 2012-08-01 00:00:00
[NAME], [NAME] | Animal |  | 2012-07-02 00:00:00 | 2012-07-23 00:00:00 |  |  | 70 | 9 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
[NAME], [NAME] | Animal |  | 2012-08-01 00:00:00 | 2012-08-30 00:00:00 |  |  | 88 | 11 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Weber, [NAME] | Horticulture |  | 2012-07-02 00:00:00 | 2012-07-30 00:00:00 |  |  | 90.25 | 12 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Weber, [NAME] | Horticulture |  | 2012-08-01 00:00:00 | 2012-08-31 00:00:00 |  |  | 106.5 | 15 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Weeks, [NAME] | Animal |  | 2012-07-02 00:00:00 | 2012-07-30 00:00:00 |  |  | 30 | 5 |  | 2012-07-31 00:00:00 | 2012-08-02 00:00:00
Winslow, [NAME] | Horticulture |  | 2012-07-02 00:00:00 | 2012-07-31 00:00:00 |  |  | 115.5 | 18 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Winslow, [NAME] | Horticulture |  | 2012-08-01 00:00:00 | 2012-08-30 00:00:00 |  |  | 98.75 | 16 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Ybanez, [NAME] | Wildlife |  | 2012-07-05 00:00:00 | 2012-07-25 00:00:00 |  |  | 15 | 6 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Zayas, Samantha | Biology |  | 2012-07-02 00:00:00 | 2012-07-31 00:00:00 |  |  | 34 | 17 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00