Spreadsheet: 889774d1740686183-need-excel-formula-to-show-location-wise-number-of-hires-in-specific-month-to-upload-sabahi2-
Sheet: Raw Data

Name, Surname | Location | Vacancy Specialization | Seniority | Start Date | Termination  Date | Column1 | Surname, Name |  |  | Location | Seniority
AAA1, BBB1 | [NAME] | Release/Configuration Manager | Regular | 2016-02-24 00:00:00 | 2017-02-24 00:00:00 |  |  |  |  |  |  | =[@[Termination  Date]]-[@[Start Date]]+DAYS([@[Termination  Date]],[@[Start Date]])
AAA2, BBB2 | Kyiv | Release/Configuration Manager | Regular | 2016-02-24 00:00:00 | 2017-03-17 00:00:00
AAA3, BBB3 | Bucharest | Office support | Junior | 2016-02-23 00:00:00 | 2017-05-01 00:00:00
AAA4, BBB4 | London | [NAME] | Regular | 2016-02-23 00:00:00 | 2017-05-31 00:00:00
AAA5, BBB5 | New York | [NAME] | Team Lead | 2016-02-22 00:00:00 | 2017-06-01 00:00:00
AAA6, BBB6 | Wroclaw | PMO | Regular | 2016-02-22 00:00:00 | 2017-06-04 00:00:00
AAA7, BBB7 | Lodz | HTML | Senior | 2016-02-22 00:00:00 | 2017-06-04 00:00:00
AAA8, BBB8 | [NAME] | [NAME] | Senior | 2016-02-22 00:00:00 | 2017-06-08 00:00:00
AAA9, BBB9 | Kyiv | [NAME] | Regular | 2016-02-22 00:00:00 | 2017-06-13 00:00:00
AAA10, BBB10 | Bucharest | PMO | Senior | 2016-02-22 00:00:00 | 2017-06-19 00:00:00
AAA11, BBB11 | London | PMO | Regular | 2016-02-19 00:00:00 | 2017-06-26 00:00:00
AAA12, BBB12 | New York | PMO | Junior | 2016-02-18 00:00:00 | 2017-07-06 00:00:00
AAA13, BBB13 | Wroclaw | [NAME] | Senior | 2016-02-17 00:00:00 | 2017-07-26 00:00:00
AAA14, BBB14 | Lodz | QA | Regular | 2016-02-17 00:00:00 | 2017-08-25 00:00:00
AAA15, BBB15 | [NAME] | Support/Helpdesk | Regular | 2016-02-16 00:00:00 | 2017-10-04 00:00:00
AAA16, BBB16 | Kyiv | Support/Helpdesk | Regular | 2016-02-16 00:00:00 | 2017-11-23 00:00:00
AAA17, BBB17 | Bucharest | HTML | Senior | 2016-02-16 00:00:00 | 2018-01-22 00:00:00
AAA18, BBB18 | London | [NAME] | Regular | 2016-02-16 00:00:00 | 2018-04-02 00:00:00
AAA19, BBB19 | New York | Analyst | Regular | 2016-02-16 00:00:00 | 2018-06-21 00:00:00
AAA20, BBB20 | Wroclaw | Mainframe | Senior | 2016-02-15 00:00:00 | 2018-09-19 00:00:00
AAA21, BBB21 | Lodz | Mainframe | Senior | 2016-02-15 00:00:00 | 2018-12-28 00:00:00
AAA22, BBB22 | [NAME] | Mainframe | Senior | 2016-02-15 00:00:00 | 2018-12-13 00:00:00
AAA23, BBB23 | Kyiv | Mainframe | Senior | 2016-02-15 00:00:00 | 2018-11-23 00:00:00
AAA24, BBB24 | Bucharest | Mainframe | Senior | 2016-02-15 00:00:00 | 2018-10-24 00:00:00
AAA25, BBB25 | London | Mainframe | Senior | 2016-02-15 00:00:00 | 2018-07-27 00:00:00
AAA26, BBB26 | New York | Mainframe | Senior | 2016-02-15 00:00:00 | 2019-01-20 00:00:00
AAA27, BBB27 | Wroclaw | Mainframe | Senior | 2016-02-15 00:00:00 | 2019-01-01 00:00:00
AAA28, BBB28 | Lodz | Mainframe | Senior | 2016-02-15 00:00:00 | 2019-02-04 00:00:00
AAA29, [NAME] | [NAME] | Mainframe | Senior | 2016-02-15 00:00:00 | 2019-01-20 00:00:00
AAA30, BBB30 | Kyiv | [NAME] | Regular | 2016-02-12 00:00:00 | 2018-12-31 00:00:00
AAA31, BBB31 | Bucharest | QA | Regular | 2016-02-12 00:00:00 | 2018-12-01 00:00:00
AAA32, BBB32 | London | Analyst | Regular | 2016-02-11 00:00:00 | 2018-09-03 00:00:00
AAA33, BBB33 | New York | QA | Junior | 2016-02-09 00:00:00 | 2018-10-10 00:00:00
AAA34, BBB34 | Wroclaw | [NAME] | Regular | 2016-02-09 00:00:00 | 2018-11-17 00:00:00
AAA35, BBB35 | Lodz | [NAME] | Senior | 2016-02-08 00:00:00 | 2018-12-25 00:00:00
AAA36, BBB36 | [NAME] | [NAME] | Senior | 2016-02-05 00:00:00 | 2018-12-10 00:00:00
AAA37, BBB37 | Kyiv | [NAME] | Regular | 2016-02-02 00:00:00 | 2018-11-20 00:00:00
AAA38, BBB38 | Bucharest | [NAME] | Regular | 2016-02-02 00:00:00 | 2018-10-21 00:00:00
AAA39, BBB39 | London | QA | Regular | 2016-02-02 00:00:00 | 2018-07-24 00:00:00
AAA40, BBB40 | New York | [NAME] | Senior | 2016-02-02 00:00:00 | 2018-09-03 00:00:00
AAA41, BBB41 | Wroclaw | [NAME] | Senior | 2016-02-02 00:00:00 | 2018-10-15 00:00:00
AAA42, BBB42 | Lodz | System Administrator | Regular | 2016-01-29 00:00:00 | 2018-09-30 00:00:00
AAA43, BBB43 | [NAME] | Office support | Senior | 2016-01-28 00:00:00 | 2018-09-10 00:00:00
AAA44, BBB44 | Kyiv | Analyst | Senior | 2016-01-28 00:00:00 | 2018-08-11 00:00:00
AAA45, BBB45 | Bucharest | PMO | Regular | 2016-01-25 00:00:00 | 2018-05-14 00:00:00
AAA46, BBB46 | London | [NAME] | Senior | 2016-01-20 00:00:00 | 2018-06-27 00:00:00
AAA47, BBB47 | New York | [NAME] | Senior | 2016-01-20 00:00:00 | 2018-08-11 00:00:00
AAA48, BBB48 | Wroclaw | [NAME] | Senior | 2016-01-20 00:00:00 | 2018-09-26 00:00:00
[NAME], BBB49 | Lodz | [NAME] | Senior | 2016-01-20 00:00:00 | 2018-11-11 00:00:00
AAA50, [NAME] | [NAME] | [NAME] | Senior | 2016-01-20 00:00:00 | 2018-12-28 00:00:00
AAA51, BBB51 | Kyiv | JavaScript | Senior | 2016-01-20 00:00:00 | 2019-02-13 00:00:00
AAA52, BBB52 | Bucharest | JavaScript | Senior | 2016-01-20 00:00:00 | 2019-04-02 00:00:00
AAA53, BBB53 | London | [NAME] | Senior | 2016-01-20 00:00:00 | 2019-05-20 00:00:00
[NAME], BBB54 | New York | [NAME] | Senior | 2016-01-20 00:00:00 | 2019-07-08 00:00:00
AAA55, BBB55 | Wroclaw | [NAME] | Senior | 2016-01-20 00:00:00 | 2019-08-26 00:00:00
AAA56, BBB56 | Lodz | [NAME] | Senior | 2016-01-20 00:00:00 | 2019-10-15 00:00:00
AAA57, BBB57 | [NAME] | [NAME] | Senior | 2016-01-20 00:00:00 | 2019-09-30 00:00:00
AAA58, BBB58 | Kyiv | Project Manager | Senior | 2016-01-18 00:00:00 | 2019-09-10 00:00:00
AAA59, BBB59 | Bucharest | [NAME] | Regular | 2016-01-18 00:00:00 | 2019-08-11 00:00:00
[NAME], BBB60 | London | [NAME] | Regular | 2016-01-18 00:00:00 | 2019-05-14 00:00:00
AAA61, BBB61 | New York | [NAME] | Regular | 2016-01-18 00:00:00 | 2019-07-06 00:00:00
AAA62, BBB62 | Wroclaw | [NAME] | Regular | 2016-01-18 00:00:00 | 2019-08-28 00:00:00
AAA63, BBB63 | Lodz | QA | Senior | 2016-01-18 00:00:00 | 2019-10-21 00:00:00
AAA64, BBB64 | [NAME] | [NAME] | Senior | 2016-01-18 00:00:00 | 2019-12-14 00:00:00
AAA65, BBB65 | Kyiv | Mainframe | Senior | 2016-01-18 00:00:00 | 2020-02-07 00:00:00
AAA66, BBB66 | Bucharest | Mainframe | Senior | 2016-01-18 00:00:00 | 2020-04-03 00:00:00
AAA67, BBB67 | London | Mainframe | Senior | 2016-01-18 00:00:00 | 2020-05-29 00:00:00
AAA68, BBB68 | New York | [NAME] | Senior | 2016-01-18 00:00:00 | 2020-07-25 00:00:00
AAA69, BBB69 | Wroclaw | [NAME] | Senior | 2016-01-18 00:00:00 | 2020-09-20 00:00:00
AAA70, BBB70 | Lodz | [NAME] | Senior | 2016-01-18 00:00:00 | 2020-11-17 00:00:00
AAA71, BBB71 | [NAME] | [NAME] | Senior | 2016-01-18 00:00:00 | 2021-01-14 00:00:00
AAA72, BBB72 | Kyiv | [NAME] | Senior | 2016-01-18 00:00:00 | 2021-03-14 00:00:00
AAA73, BBB73 | Bucharest | [NAME] | Senior | 2016-01-18 00:00:00 | 2021-05-13 00:00:00
AAA74, BBB74 | London | [NAME] | Senior | 2016-01-18 00:00:00 | 2021-07-12 00:00:00
AAA75, BBB75 | New York | [NAME] | Senior | 2016-01-18 00:00:00 | 2021-09-11 00:00:00
AAA76, BBB76 | Wroclaw | [NAME] | Senior | 2016-01-18 00:00:00 | 2021-11-11 00:00:00
AAA77, BBB77 | Lodz | [NAME] | Senior | 2016-01-18 00:00:00 | 2022-01-12 00:00:00
AAA78, BBB78 | [NAME] | [NAME] | Senior | 2016-01-18 00:00:00 | 2022-03-15 00:00:00
AAA79, BBB79 | Kyiv | [NAME] | Senior | 2016-01-18 00:00:00 | 2022-05-17 00:00:00
AAA80, BBB80 | Bucharest | [NAME] | Senior | 2016-01-18 00:00:00 | 2022-07-19 00:00:00
AAA81, BBB81 | London | [NAME] | Senior | 2016-01-18 00:00:00 | 2022-09-21 00:00:00
AAA82, BBB82 | New York | PMO | Regular | 2016-01-15 00:00:00 | 2022-11-25 00:00:00
AAA83, BBB83 | Wroclaw | QA | Senior | 2016-01-04 00:00:00 | 2022-11-10 00:00:00
AAA84, BBB84 | Lodz | Release/Configuration Manager | Team Lead | 2016-01-04 00:00:00 | 2022-10-21 00:00:00
AAA85, BBB85 | [NAME] | HR&Recruitment | Senior | 2016-01-04 00:00:00 | 2022-09-21 00:00:00
AAA86, BBB86 | Kyiv | HR&Recruitment | Senior | 2016-01-04 00:00:00 | 2022-06-24 00:00:00
[NAME], BBB87 | Bucharest | .Net | Team Lead | 2015-12-31 00:00:00 | 2022-08-30 00:00:00
AAA88, BBB88 | London | .Net | Junior | 2015-12-31 00:00:00 | 2022-11-06 00:00:00
AAA89, BBB89 | New York | Release/Configuration Manager | Senior | 2015-12-31 00:00:00 | 2023-01-13 00:00:00
AAA90, BBB90 | Wroclaw | Tech Writer | Senior | 2015-12-31 00:00:00 | 2023-03-23 00:00:00
AAA91, BBB91 | Lodz | QA | Regular | 2015-12-23 00:00:00 | 2023-06-01 00:00:00
AAA92, BBB92 | [NAME] | [NAME] | Senior | 2015-12-21 00:00:00 | 2023-08-10 00:00:00
AAA93, BBB93 | Kyiv | Project Manager | Manager | 2015-12-18 00:00:00 | 2023-10-20 00:00:00
AAA94, BBB94 | Bucharest | Project Manager | Senior | 2015-12-16 00:00:00 | 2023-12-30 00:00:00
AAA95, BBB95 | London | [NAME] | Senior | 2015-12-09 00:00:00 | 2023-12-15 00:00:00
AAA96, BBB96 | New York | [NAME] | Team Lead | 2015-12-09 00:00:00 | 2023-11-25 00:00:00
AAA97, BBB97 | Wroclaw | [NAME] | Team Lead | 2015-12-04 00:00:00 | 2023-10-26 00:00:00
AAA98, BBB98 | Lodz | Support/Helpdesk | Regular | 2015-12-02 00:00:00 | 2023-07-29 00:00:00
AAA99, BBB99 | [NAME] | QA | Senior | 2015-12-02 00:00:00 | 2023-10-11 00:00:00
AAA100, BBB100 | Kyiv | [NAME] | Senior | 2015-12-02 00:00:00 | 2023-12-25 00:00:00
AAA101, BBB101 | Bucharest | System Administrator | Regular | 2015-11-27 00:00:00 | 2024-03-09 00:00:00
AAA102, BBB102 | London | [NAME] | Regular | 2015-11-27 00:00:00 | 2024-05-24 00:00:00
AAA103, BBB103 | New York | Project Manager | Manager | 2015-11-26 00:00:00 | 2024-08-08 00:00:00
AAA104, BBB104 | Wroclaw | [NAME] | Senior | 2015-11-25 00:00:00 | 2024-07-24 00:00:00
AAA105, BBB105 | Lodz | [NAME] | Senior | 2015-11-25 00:00:00 | 2024-07-04 00:00:00
AAA106, BBB106 | [NAME] | [NAME] | Senior | 2015-11-25 00:00:00 | 2024-06-04 00:00:00
AAA107, [NAME] | Kyiv | JavaScript | Senior | 2015-11-18 00:00:00 | 2024-03-07 00:00:00
AAA108, BBB108 | Bucharest | QA | Senior | 2015-11-10 00:00:00 | 2024-05-25 00:00:00
AAA109, BBB109 | London | Release/Configuration Manager | Senior | 2015-11-06 00:00:00 | 2024-08-13 00:00:00
AAA110, BBB110 | New York | [NAME] | Senior | 2015-10-30 00:00:00 | 2024-11-01 00:00:00
AAA111, BBB111 | Wroclaw | .Net | Regular | 2015-10-21 00:00:00 | 2025-01-21 00:00:00
AAA112, BBB112 | Lodz | [NAME] | Senior | 2015-10-21 00:00:00 | 2025-04-12 00:00:00
AAA113, BBB113 | [NAME] | [NAME] | Senior | 2015-10-19 00:00:00 | 2025-07-03 00:00:00
AAA114, BBB114 | Kyiv | [NAME] | Regular | 2015-10-19 00:00:00 | 2025-06-18 00:00:00
AAA115, BBB115 | Bucharest | [NAME] | Senior | 2015-10-19 00:00:00 | 2025-05-29 00:00:00
AAA116, BBB116 | London | QA | Regular | 2015-10-08 00:00:00 | 2025-04-29 00:00:00
AAA117, BBB117 | New York | [NAME] | Regular | 2015-10-08 00:00:00 | 2025-01-30 00:00:00
AAA118, BBB118 | Wroclaw | [NAME] | Senior | 2015-10-08 00:00:00 | 2025-04-25 00:00:00
AAA119, BBB119 | Lodz | Analyst | Regular | 2015-09-24 00:00:00 | 2025-07-19 00:00:00
AAA120, BBB120 | [NAME] | QA | Senior | 2015-09-23 00:00:00 | 2025-10-13 00:00:00
AAA121, BBB121 | Kyiv | Analyst | Senior | 2015-09-23 00:00:00 | 2026-01-07 00:00:00
AAA122, BBB122 | Bucharest | .Net | Regular | 2015-09-08 00:00:00 | 2026-04-04 00:00:00
AAA123, BBB123 | London | [NAME] | Regular | 2015-09-07 00:00:00 | 2026-03-20 00:00:00
AAA124, BBB124 | New York | [NAME] | Senior | 2015-09-07 00:00:00 | 2026-02-28 00:00:00
AAA125, BBB125 | Wroclaw | [NAME] | Team Lead | 2015-09-07 00:00:00 | 2026-01-29 00:00:00
AAA126, BBB126 | Lodz | [NAME] | Senior | 2015-09-03 00:00:00 | 2025-11-01 00:00:00
AAA127, BBB127 | [NAME] | QA | Senior | 2015-08-31 00:00:00 | 2026-01-30 00:00:00
AAA128, BBB128 | Kyiv | [NAME] | Senior | 2015-08-31 00:00:00 | 2026-04-30 00:00:00
AAA129, BBB129 | Bucharest | [NAME] | Senior | 2015-08-31 00:00:00 | 2026-07-30 00:00:00
AAA130, BBB130 | London | .Net | Regular | 2015-08-10 00:00:00 | 2026-07-15 00:00:00
AAA131, BBB131 | New York | .Net | Senior | 2015-08-10 00:00:00 | 2026-06-25 00:00:00
AAA132, BBB132 | Wroclaw | [NAME] | Senior | 2015-08-07 00:00:00 | 2026-05-26 00:00:00
AAA133, BBB133 | Lodz | QA | Regular | 2015-08-07 00:00:00 | 2026-02-26 00:00:00
AAA134, BBB134 | [NAME] | [NAME] | Senior | 2015-08-03 00:00:00 | 2026-05-31 00:00:00
AAA135, BBB135 | Kyiv | Other | Senior | 2015-07-30 00:00:00 | 2026-05-16 00:00:00
AAA136, BBB136 | Bucharest | System Administrator | Senior | 2015-07-30 00:00:00 | 2026-04-26 00:00:00
AAA137, BBB137 | London | Unix | Team Lead | 2015-07-30 00:00:00 | 2026-03-27 00:00:00
[NAME], BBB138 | New York | [NAME] | Senior | 2015-07-03 00:00:00 | 2025-12-28 00:00:00
AAA139, BBB139 | Wroclaw | Project Manager | Senior | 2015-06-30 00:00:00 | 2026-04-03 00:00:00
AAA140, [NAME] | Lodz | [NAME] | Senior | 2015-06-29 00:00:00 | 2026-03-19 00:00:00
AAA141, BBB141 | [NAME] | [NAME] | Senior | 2015-06-17 00:00:00 | 2026-02-27 00:00:00
AAA142, BBB142 | Kyiv | [NAME] | Senior | 2015-06-03 00:00:00 | 2026-01-28 00:00:00
AAA143, BBB143 | Bucharest | System Administrator | Senior | 2015-06-03 00:00:00 | 2025-10-31 00:00:00
AAA144, BBB144 | London | System Administrator | Senior | 2015-06-03 00:00:00 | 2026-02-07 00:00:00
AAA145, BBB145 | New York | [NAME] | Regular | 2015-05-25 00:00:00 | 2026-05-18 00:00:00
AAA146, BBB146 | Wroclaw | [NAME] | Regular | 2015-04-27 00:00:00 | 2026-05-03 00:00:00
AAA147, BBB147 | Lodz | Project Manager | Manager | 2015-04-15 00:00:00 | 2026-04-13 00:00:00
AAA148, BBB148 | [NAME] | [NAME] | Senior | 2014-11-06 00:00:00 | 2026-03-14 00:00:00
AAA149, BBB149 | Kyiv | [NAME] | Senior | 2014-11-06 00:00:00 | 2025-12-15 00:00:00