Spreadsheet: 796323d1663225417-sum-divide-values-between-two-tables-2022-09-15-oeldere-philchi-utilization-between-dates
Sheet: Sheet1

Name | Start Date | End Date |  |  | Resource Name | Task Billable | Hours | Cell Date | Month | Quartal |  |  | Month | Quartal |  | KEY
Annelise Reside | 2022-01-01 00:00:00 |  |  |  | Annelise Reside | Y | 8 | 2022-02-01 00:00:00 |  |  |  |  | 1 | 1 |  | Eligible Hours = Wokring from Start Date to End Date OR Current Date (excludes Weekends and Holidays)
[NAME] | 2022-01-01 00:00:00 |  |  |  | Annelise Reside | Y | 6 | 2022-02-15 00:00:00 |  |  |  |  | 2 | 1 |  | Billable Hours = Hours tagged with "Y" in Task Billable column between Start and End/Current Date
[NAME] | 2022-01-01 00:00:00 | 2022-04-15 00:00:00 |  |  | Annelise Reside | N | 8 | 2022-03-15 00:00:00 |  |  |  |  | 3 | 1 |  | Utlization = Billable Hours /  Eligible Hours
[NAME] | 2022-04-01 00:00:00 |  |  |  | Annelise Reside | Y | 8 | 2022-04-01 00:00:00 |  |  |  |  | 4 | 2
[NAME] | 2022-01-01 00:00:00 |  |  |  | Annelise Reside | Y | 7 | 2022-07-15 00:00:00 |  |  |  |  | 5 | 2
[NAME] | 2022-01-01 00:00:00 |  |  |  | Annelise Reside | Y | 8 | 2022-09-01 00:00:00 |  |  |  |  | 6 | 2
[NAME] | 2022-01-01 00:00:00 | 2022-06-01 00:00:00 |  |  | [NAME] | N | 8 | 2022-03-15 00:00:00 |  |  |  |  | 7 | 3 |  | MONTHLY UTILIZATION |  |  |  |  | QUARTERLY UTILIZATION
[NAME] | 2022-05-15 00:00:00 |  |  |  | [NAME] | Y | 8 | 2022-04-01 00:00:00 |  |  |  |  | 8 | 3 |  |  | Billable Hours | Eligible Hours | Utilization |  | Q1 (Jan-Mar)
Orton Timbrell | 2022-01-01 00:00:00 |  |  |  | [NAME] | Y | 7 | 2022-07-15 00:00:00 |  |  |  |  | 9 | 3 |  | 2022-01-01 00:00:00 |  | MAX(0,NETWORKDAYS([@[Start Date]],today()-WEEKDAY(today()),Holidays)),MAX(0,NETWORKDAYS([@[Start Date]],[@[End Date]],Holidays)))*8 |  |  | Q2 (Apr-Jun)
[NAME] | 2022-09-01 00:00:00 |  |  |  | [NAME] | Y | 8 | 2022-02-01 00:00:00 |  |  |  |  | 10 | 4 |  | 2022-02-01 00:00:00 |  |  |  |  | Q3 (Jul-Sep) |  | These are incorrect
 |  |  |  |  | [NAME] | Y | 6 | 2022-02-15 00:00:00 |  |  |  |  | 11 | 4 |  | 2022-03-01 00:00:00 |  |  |  |  | 4Q (Oct-Dec)
 |  |  |  |  | [NAME] | N | 8 | 2022-03-15 00:00:00 |  |  |  |  | 12 | 4 |  | 2022-04-01 00:00:00
Company Holidays |  |  |  |  | [NAME] | Y | 8 | 2022-06-01 00:00:00 |  |  |  |  |  |  |  | 2022-05-01 00:00:00
2022-01-01 00:00:00 | New Year's Day |  |  |  | [NAME] | Y | 7 | 2022-09-01 00:00:00 |  |  |  |  |  |  |  | 2022-06-01 00:00:00
2022-05-30 00:00:00 | Memorial Day |  |  |  | [NAME] | Y | 8 | 2022-01-15 00:00:00 |  |  |  |  |  |  |  | 2022-07-01 00:00:00
2022-07-04 00:00:00 | Independence Day |  |  |  | [NAME] | Y | 6 | 2022-02-15 00:00:00 |  |  |  |  |  |  |  | 2022-08-01 00:00:00
2022-11-24 00:00:00 | Thanksgiving |  |  |  | [NAME] | N | 8 | 2022-03-15 00:00:00 |  |  |  |  |  |  |  | 2022-09-01 00:00:00
2022-12-26 00:00:00 | Christmas Day |  |  |  | [NAME] | Y | 8 | 2022-04-01 00:00:00 |  |  |  |  |  |  |  | 2022-10-01 00:00:00
 |  |  |  |  | [NAME] | Y | 7 | 2022-04-15 00:00:00 |  |  |  |  |  |  |  | 2022-11-01 00:00:00
 |  |  |  |  | [NAME] | Y | 8 | 2022-05-01 00:00:00 |  |  |  |  |  |  |  | 2022-12-01 00:00:00
 |  |  |  |  | [NAME] | Y | 6 | 2022-07-15 00:00:00
 |  |  |  |  | [NAME] | Y | 8 | 2022-04-01 00:00:00
 |  |  |  |  | [NAME] | Y | 7 | 2022-07-15 00:00:00
 |  |  |  |  | [NAME] | Y | 8 | 2022-02-01 00:00:00 |  |  |  |  |  | Som van Hours | Kolomlabels
 |  |  |  |  | [NAME] | Y | 6 | 2022-02-15 00:00:00 |  |  |  |  |  | Rijlabels | N | Y | Eindtotaal
 |  |  |  |  | [NAME] | N | 8 | 2022-03-15 00:00:00 |  |  |  |  |  | 1 | 72 | 112 | 184
 |  |  |  |  | [NAME] | Y | 8 | 2022-04-01 00:00:00 |  |  |  |  |  | 1 |  | 8 | 8
 |  |  |  |  | [NAME] | Y | 7 | 2022-07-15 00:00:00 |  |  |  |  |  | 2 |  | 104 | 104
 |  |  |  |  | [NAME] | Y | 8 | 2022-02-01 00:00:00 |  |  |  |  |  | 3 | 72 |  | 72
 |  |  |  |  | [NAME] | Y | 6 | 2022-02-15 00:00:00 |  |  |  |  |  | 2 |  | 95 | 95
 |  |  |  |  | [NAME] | N | 8 | 2022-03-15 00:00:00 |  |  |  |  |  | 4 |  | 71 | 71
 |  |  |  |  | [NAME] | Y | 8 | 2022-06-01 00:00:00 |  |  |  |  |  | 5 |  | 8 | 8
 |  |  |  |  | [NAME] | Y | 7 | 2022-09-15 00:00:00 |  |  |  |  |  | 6 |  | 16 | 16
 |  |  |  |  | [NAME] | Y | 8 | 2022-02-01 00:00:00 |  |  |  |  |  | 3 |  | 77 | 77
 |  |  |  |  | [NAME] | Y | 6 | 2022-02-15 00:00:00 |  |  |  |  |  | 7 |  | 55 | 55
 |  |  |  |  | [NAME] | N | 8 | 2022-03-15 00:00:00 |  |  |  |  |  | 9 |  | 22 | 22
 |  |  |  |  | [NAME] | Y | 8 | 2022-04-01 00:00:00 |  |  |  |  |  | Eindtotaal | 72 | 284 | 356
 |  |  |  |  | [NAME] | Y | 7 | 2022-07-15 00:00:00
 |  |  |  |  | Orton Timbrell | Y | 8 | 2022-02-01 00:00:00
 |  |  |  |  | Orton Timbrell | Y | 6 | 2022-02-15 00:00:00
 |  |  |  |  | Orton Timbrell | N | 8 | 2022-03-15 00:00:00
 |  |  |  |  | Orton Timbrell | Y | 8 | 2022-04-01 00:00:00
 |  |  |  |  | Orton Timbrell | Y | 7 | 2022-07-15 00:00:00
 |  |  |  |  | [NAME] | Y | 8 | 2022-02-01 00:00:00
 |  |  |  |  | [NAME] | Y | 6 | 2022-02-15 00:00:00
 |  |  |  |  | [NAME] | N | 8 | 2022-03-15 00:00:00
 |  |  |  |  | [NAME] | Y | 8 | 2022-04-01 00:00:00
 |  |  |  |  | [NAME] | Y | 7 | 2022-07-15 00:00:00