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

Student Name | Department | Title | Start Date | End Date | Pay Rate
Aceves, Teresa | Horticulture | [NAME] | 2012-07-01 00:00:00 | 2013-02-24 00:00:00
Aceves, Vivian | Earth Sciences | Short Term | 2012-09-04 00:00:00 | 2013-06-30 00:00:00 | 8
Acosta, [NAME] | Horticulture | [NAME] | 2012-07-01 00:00:00 | 2013-02-24 00:00:00
Andrzejewski, Britnee | Animal | [NAME] | 2012-07-01 00:00:00 | 2013-02-24 00:00:00
Antillon, [NAME] | Physics Engineering | [NAME] | 2012-08-01 00:00:00 | 2013-02-22 00:00:00
[NAME], [NAME] | Horticulture | [NAME] | 2012-07-01 00:00:00 | 2012-08-27 00:00:00
Balsiger, Joel | Horticulture | [NAME] | 2012-07-01 00:00:00 | 2013-02-24 00:00:00
Brunson, Naomi | Animal | [NAME] | 2012-07-01 00:00:00 | 2013-02-24 00:00:00
Castaneda, [NAME] | Horticulture | [NAME] | 2012-07-01 00:00:00 | 2012-08-16 00:00:00
[NAME], Shannon | Animal | [NAME] | 2012-07-01 00:00:00 | 2013-02-24 00:00:00
Eccles, Samantha | Animal | [NAME] | 2012-07-01 00:00:00 | 2013-02-24 00:00:00
Espinosa, Stephen | Physics Engineering | [NAME] | 2012-08-01 00:00:00 | 2013-02-22 00:00:00
Garbiso, Tiffany | Earth Sciences | [NAME] | 2012-08-27 00:00:00 | 2013-02-22 00:00:00
[NAME], Adrian | Horticulture | [NAME] | 2012-07-01 00:00:00 | 2013-02-24 00:00:00
[NAME], [NAME] | NSD | [NAME] | 2012-07-01 00:00:00 | 2013-02-22 00:00:00
[NAME], [NAME] | Earth Sciences | [NAME] | 2012-07-01 00:00:00 | 2013-02-22 00:00:00
[NAME], [NAME] | Animal | [NAME] | 2012-07-01 00:00:00 | 2013-02-24 00:00:00
[NAME], [NAME] | Horticulture | [NAME] | 2012-07-01 00:00:00 | 2013-02-24 00:00:00
Jordan, [NAME] | Horticulture | [NAME] | 2012-07-01 00:00:00 | 2013-02-24 00:00:00
Jordan, [NAME] | Horticulture | [NAME] | 2012-07-01 00:00:00 | 2013-02-24 00:00:00
Klintong, [NAME] | Chemistry | [NAME] | 2012-08-27 00:00:00 | 2012-12-14 00:00:00
[NAME], [NAME] | Physics Engineering | [NAME] | 2012-08-01 00:00:00 | 2012-08-31 00:00:00
[NAME], [NAME] | Physics Engineering | Short Term | 2012-09-01 00:00:00 | 2013-06-30 00:00:00 | 13.27
Lew, Toni | Animal | [NAME] | 2012-07-01 00:00:00 | 2013-02-24 00:00:00
[NAME], [NAME] | Horticulture | [NAME] | 2012-07-01 00:00:00 | 2012-08-27 00:00:00
[NAME], [NAME] | RVT | [NAME] | 2012-08-26 00:00:00 | 2013-02-24 00:00:00
Lopez, Blanca | Animal | [NAME] | 2012-07-01 00:00:00 | 2012-08-27 00:00:00
Machaca, Patty | Horticulture | [NAME] | 2012-07-01 00:00:00 | 2013-02-24 00:00:00
Marquez, [NAME] | Earth Sciences | [NAME] | 2012-07-01 00:00:00 | 2013-02-22 00:00:00
Meraz, Stephen | Horticulture | [NAME] | 2012-07-01 00:00:00 | 2012-08-27 00:00:00
[NAME], [NAME] | Animal | [NAME] | 2012-07-01 00:00:00 | 2013-02-24 00:00:00
Moore, [NAME] | Animal | [NAME] | 2012-07-01 00:00:00 | 2013-02-24 00:00:00
Mowery, Blair | Animal | [NAME] | 2012-07-01 00:00:00 | 2013-02-24 00:00:00
[NAME], Orlando | Animal | [NAME] | 2012-07-01 00:00:00 | 2012-08-27 00:00:00
Pawlak, Mary | Horticulture | [NAME] | 2012-08-26 00:00:00 | 2013-02-22 00:00:00
Payne, [NAME] | Earth Sciences | [NAME] | 2012-07-01 00:00:00 | 2012-08-26 00:00:00
Porras, Victoria | Horticulture | [NAME] | 2012-07-01 00:00:00 | 2013-02-24 00:00:00
Powers, [NAME] | Earth Sciences | [NAME] | 2012-08-01 00:00:00 | 2013-02-22 00:00:00
[NAME], [NAME] | NSD | [NAME] | 2012-07-01 00:00:00 | 2013-02-22 00:00:00
Randall, [NAME] | Grants | [NAME] | 2012-07-02 00:00:00 | 2012-08-26 00:00:00
Randall, [NAME] | Grants | Short Term | 2012-08-27 00:00:00 | 2013-06-30 00:00:00 | 8
Redinger, [NAME] | Grants | [NAME] | 2012-07-02 00:00:00 | 2013-02-22 00:00:00
Ruiz, Briana | NSD | [NAME] | 2012-07-01 00:00:00 | 2013-02-22 00:00:00
Salazar, Coreena | Biology | [NAME] | 2012-08-27 00:00:00 | 2012-12-14 00:00:00
Smith, Lindsey | Animal | Prof Exp. | 2012-07-01 00:00:00 | 2013-06-30 00:00:00 | 13.27
Solis, Robyn | Wildlife | [NAME] | 2012-07-01 00:00:00 | 2012-08-26 00:00:00
[NAME], [NAME] | Animal | [NAME] | 2012-07-01 00:00:00 | 2013-02-24 00:00:00
Tamillo, Blanca | Horticulture | [NAME] | 2012-07-01 00:00:00 | 2012-08-27 00:00:00
[NAME], [NAME] | Math | [NAME] | 2012-07-02 00:00:00 | 2012-08-24 00:00:00
[NAME], [NAME] | Animal | [NAME] | 2012-07-01 00:00:00 | 2013-02-24 00:00:00
Weber, [NAME] | Horticulture | [NAME] | 2012-07-01 00:00:00 | 2013-02-24 00:00:00
Weeks, [NAME] | Animal | [NAME] | 2012-07-01 00:00:00 | 2012-08-27 00:00:00
Winslow, [NAME] | Horticulture | [NAME] | 2012-07-01 00:00:00 | 2013-02-24 00:00:00
Ybanez, [NAME] | Wildlife | [NAME] | 2012-07-01 00:00:00 | 2012-08-26 00:00:00
Zayas, Samantha | Biology | [NAME] | 2012-07-01 00:00:00 | 2012-07-31 00:00:00
[NAME], [NAME] | Math | [NAME] | 2012-08-27 00:00:00 | 2013-02-22 00:00:00
[NAME], [NAME] | Math | [NAME] | 2012-08-27 00:00:00 | 2013-02-22 00:00:00