Spreadsheet: 679109d1590194449-what-is-wrong-with-my-formula-formula-monthly-hc-and-monthly-salary-automation
Sheet: DataSheet

Basic Staff Info (BambooHR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-06-30 00:00:00 | 2020-07-31 00:00:00 | 2020-08-31 00:00:00 | 2020-09-30 00:00:00 | 2020-10-31 00:00:00 | 2020-11-30 00:00:00 | 2020-12-31 00:00:00 | 2020-06-30 00:00:00 | 2020-07-31 00:00:00 | 2020-08-31 00:00:00 | 2020-09-30 00:00:00 | 2020-10-31 00:00:00 | 2020-11-30 00:00:00 | 2020-12-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Headcount Development 2020 |  |  |  |  |  |  | Monthly Salaries 2020
Employee # | Country | Employee Class | Department | Last name, First name | Contract Start Date | Contract End Date | [NAME] taken (YTD) | Vacation Current balance | Vacation (E) Current balance | Name of the Health Insurance | IBAN | BIC/Swift Code | Holder of the Account | Currency | Annual Salary | No. of Salaries | Monthly Gross Salary | Paid Leave Start Date | Paid Leave End Date | Bonus Amount | Jun 2020 | Jul 2020 | Aug 2020 | Sep 2020 | Oct 2020 | Nov 2020 | Dec 2020 | June-20 | July-20 | August-20 | [NAME] | October-20 | November-20 | December-20
 |  |  |  |  | 2019-11-23 00:00:00 | 2021-11-22 00:00:00 |  |  |  |  |  |  |  | EUR | 68400 | 12
 |  |  |  |  | 2019-11-23 00:00:00 | 2020-10-22 00:00:00 |  |  |  |  |  |  |  | EUR | 46800 | 12
 |  |  |  |  | 2019-11-23 00:00:00 | 2020-11-22 00:00:00 |  |  |  |  |  |  |  | EUR | 69600 | 12
 |  |  |  |  | 2019-11-23 00:00:00 |  |  |  |  |  |  |  |  | EUR | 150000 | 12
 |  |  |  |  | 2019-11-24 00:00:00 | 2021-11-23 00:00:00 |  |  |  |  |  |  |  | EUR | 96000 | 12
 |  |  |  |  | 2019-11-30 00:00:00 | 2021-11-30 00:00:00 |  |  |  |  |  |  |  | EUR | 60000 | 12
 |  |  |  |  | 2019-12-01 00:00:00 |  |  |  |  |  |  |  |  | EUR | 90000 | 12
 |  |  |  |  | 2019-12-02 00:00:00 | 2021-12-01 00:00:00 |  |  |  |  |  |  |  | EUR | 43000 | 12
 |  |  |  |  | 2019-12-02 00:00:00 | 2020-06-01 00:00:00 |  |  |  |  |  |  |  | EUR | 1557 | 12
 |  |  |  |  | 2019-12-05 00:00:00 | 2021-12-04 00:00:00 |  |  |  |  |  |  |  | EUR | 70000 | 12
 |  |  |  |  | 2019-12-16 00:00:00 | 2021-06-15 00:00:00 |  |  |  |  |  |  |  | EUR | 65000 | 12
 |  |  |  |  | 2020-01-01 00:00:00 |  |  |  |  |  |  |  |  | EUR | 130000 | 12
 |  |  |  |  | 2020-01-02 00:00:00 |  |  |  |  |  |  |  |  | EUR | 125782 | 12
 |  |  |  |  | 2020-02-01 00:00:00 | 2022-01-31 00:00:00 |  |  |  |  |  |  |  | EUR | 60000 | 12
 |  |  |  |  | 2020-02-01 00:00:00 |  |  |  |  |  |  |  |  | EUR | 170000 | 12
 |  |  |  |  | 2020-02-10 00:00:00 | 2020-07-29 00:00:00 |  |  |  |  |  |  |  | EUR | 1621 | 12
 |  |  |  |  | 2020-02-15 00:00:00 | 2022-02-14 00:00:00 |  |  |  |  |  |  |  | EUR | 167304 | 12
 |  |  |  |  | 2020-02-19 00:00:00 | 2022-02-18 00:00:00 |  |  |  |  |  |  |  | EUR | 64000 | 12
 |  |  |  |  | 2020-02-24 00:00:00 | 2020-08-23 00:00:00 |  |  |  |  |  |  |  | EUR | 1620 | 12
 |  |  |  |  | 2020-04-01 00:00:00 | 2022-03-31 00:00:00 |  |  |  |  |  |  |  | EUR | 48000 | 12
 |  |  |  |  | 2020-04-01 00:00:00 |  |  |  |  |  |  |  |  | EUR | 130000 | 12
 |  |  |  |  | 2020-04-20 00:00:00 | 2022-04-19 00:00:00 |  |  |  |  |  |  |  | EUR | 45600 | 12
 |  |  |  |  | 2020-05-01 00:00:00 | 2022-04-30 00:00:00 |  |  |  |  |  |  |  | EUR | 84000 | 12
 |  |  |  |  | 2020-05-01 00:00:00 |  |  |  |  |  |  |  |  | EUR | 95000 | 12
 |  |  |  |  | 2020-05-16 00:00:00 | 2022-05-15 00:00:00 |  |  |  |  |  |  |  | EUR | 46800 | 12
 |  |  |  |  | 2020-07-01 00:00:00 | 2022-06-30 00:00:00 |  |  |  |  |  |  |  | EUR | 82000 | 12
 |  |  |  |  | 2020-07-01 00:00:00 | 2022-06-30 00:00:00 |  |  |  |  |  |  |  | EUR | 55248 | 12