Spreadsheet: 703816d1605186539-allocation-of-amount-between-dates-excel-forum-file-haroonkhurshid-
Sheet: Sheet1

 |  |  |  | Start Date |  |  |  |  |  |  |  | End Date
 |  | Fund | Total Shares Granted | 2020-08-10 00:00:00 | 2020-09-16 00:00:00 | 2020-12-16 00:00:00 | 2021-02-10 00:00:00 | 2021-06-16 00:00:00 | 2021-08-10 00:00:00 | 2022-02-10 00:00:00 | 2022-08-10 00:00:00
 |  | A | 8000 |  |  |  | 2000 |  | 2000 | 2000 | 2000
 |  | B | 8000 |  |  |  | 2000 |  | 2000 | 2000 | 2000
 |  | C | 8000 |  |  |  | 2000 |  | 2000 | 2000 | 2000
 |  | D | 8000 |  |  |  | 2000 |  | 2000 | 2000 | 2000
 |  | E | 3000 |  | 750 | 750 |  | 1500
 |  | F | 3000 |  | 750 | 750 |  | 1500
 |  | G | 3000 |  | 750 | 750 |  | 1500
 |  | H | 3000 |  | 750 | 750 |  | 1500
 |  |  | 44000 |  | 3000 | 3000 | 8000 | 6000 | 8000 | 8000 | 8000
 | Allocation table
 | Days | Months | A | B | C | D | E | F | G | H | Total |  | Days (A:D) | Days (E:H) | Months | A | B | C | D | E | F | G | H | Total
 | 22 | 2020-08-31 00:00:00 | 237.8378378378378 | 237.8378378378378 | 237.8378378378378 | 237.8378378378378 | 434.2105263157895 | 434.2105263157895 | 434.2105263157895 | 434.2105263157895
 | 30 | 2020-09-30 00:00:00 | 324.3243243243243 | 324.3243243243243 | 324.3243243243243 | 324.3243243243243 | 431.1740890688259 | 431.1740890688259 | 431.1740890688259 | 431.1740890688259
 | 31 | 2020-10-31 00:00:00 | 335.1351351351351 | 335.1351351351351 | 335.1351351351351 | 335.1351351351351 | 255.4945054945055 | 255.4945054945055 | 255.4945054945055 | 255.4945054945055
 | 30 | 2020-11-30 00:00:00 | 324.3243243243243 | 324.3243243243243 | 324.3243243243243 | 324.3243243243243 | 247.2527472527472 | 247.2527472527472 | 247.2527472527472 | 247.2527472527472
 | 31 | 2020-12-31 00:00:00 | 335.1351351351351 | 335.1351351351351 | 335.1351351351351 | 335.1351351351351 | 255.4945054945055 | 255.4945054945055 | 255.4945054945055 | 255.4945054945055
 | 31 | 2021-01-31 00:00:00 | 335.1351351351351 | 335.1351351351351 | 335.1351351351351 | 335.1351351351351 | 255.4945054945055 | 255.4945054945055 | 255.4945054945055 | 255.4945054945055
 | 28 | 2021-02-28 00:00:00 | 307.0031357324175 | 307.0031357324175 | 307.0031357324175 | 307.0031357324175 | 230.7692307692307 | 230.7692307692307 | 230.7692307692307 | 230.7692307692307
 | 31 | 2021-03-31 00:00:00 | 342.5414364640884 | 342.5414364640884 | 342.5414364640884 | 342.5414364640884 | 255.4945054945055 | 255.4945054945055 | 255.4945054945055 | 255.4945054945055
 | 30 | 2021-04-30 00:00:00 | 331.4917127071823 | 331.4917127071823 | 331.4917127071823 | 331.4917127071823 | 247.2527472527472 | 247.2527472527472 | 247.2527472527472 | 247.2527472527472
 | 31 | 2021-05-31 00:00:00 | 342.5414364640884 | 342.5414364640884 | 342.5414364640884 | 342.5414364640884 | 255.4945054945055 | 255.4945054945055 | 255.4945054945055 | 255.4945054945055
 | 30 | 2021-06-30 00:00:00 | 331.4917127071823 | 331.4917127071823 | 331.4917127071823 | 331.4917127071823 | 131.8681318681319 | 131.8681318681319 | 131.8681318681319 | 131.8681318681319
 | 31 | 2021-07-31 00:00:00 | 342.5414364640884 | 342.5414364640884 | 342.5414364640884 | 342.5414364640884 | 0 | 0 | 0 | 0
 | 31 | 2021-08-31 00:00:00 | 338.7581071342782 | 338.7581071342782 | 338.7581071342782 | 338.7581071342782 | 0 | 0 | 0 | 0
 | 30 | 2021-09-30 00:00:00 | 326.0869565217391 | 326.0869565217391 | 326.0869565217391 | 326.0869565217391 | 0 | 0 | 0 | 0
 | 31 | 2021-10-31 00:00:00 | 336.9565217391304 | 336.9565217391304 | 336.9565217391304 | 336.9565217391304 | 0 | 0 | 0 | 0
 | 30 | 2021-11-30 00:00:00 | 326.0869565217391 | 326.0869565217391 | 326.0869565217391 | 326.0869565217391 | 0 | 0 | 0 | 0
 | 31 | 2021-12-31 00:00:00 | 336.9565217391304 | 336.9565217391304 | 336.9565217391304 | 336.9565217391304 | 0 | 0 | 0 | 0
 | 31 | 2022-01-31 00:00:00 | 336.9565217391304 | 336.9565217391304 | 336.9565217391304 | 336.9565217391304 | 0 | 0 | 0 | 0
 | 28 | 2022-02-28 00:00:00 | 307.5906797982224 | 307.5906797982224 | 307.5906797982224 | 307.5906797982224 | 0 | 0 | 0 | 0
 | 31 | 2022-03-31 00:00:00 | 342.5414364640884 | 342.5414364640884 | 342.5414364640884 | 342.5414364640884 | 0 | 0 | 0 | 0
 | 30 | 2022-04-30 00:00:00 | 331.4917127071823 | 331.4917127071823 | 331.4917127071823 | 331.4917127071823 | 0 | 0 | 0 | 0
 | 31 | 2022-05-31 00:00:00 | 342.5414364640884 | 342.5414364640884 | 342.5414364640884 | 342.5414364640884 | 0 | 0 | 0 | 0
 | 30 | 2022-06-30 00:00:00 | 331.4917127071823 | 331.4917127071823 | 331.4917127071823 | 331.4917127071823 | 0 | 0 | 0 | 0
 | 31 | 2022-07-31 00:00:00 | 342.5414364640884 | 342.5414364640884 | 342.5414364640884 | 342.5414364640884 | 0 | 0 | 0 | 0
 | 10 | 2022-08-10 00:00:00 | 110.4972375690608 | 110.4972375690608 | 110.4972375690608 | 110.4972375690608 | 0 | 0 | 0 | 0
 | Total Expense as per Schedule |  | 7999.999999999996 | 7999.999999999996 | 7999.999999999996 | 7999.999999999996 | 3000 | 3000 | 3000 | 3000