Spreadsheet: 793394d1661444610-formula-to-calculate-monthly-salary-from-annual-salary-salary-calculation-sample
Sheet: Sheet1

 | Employee Name | Start Date | End Date | Annual Salary |  | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 | 2017-01-01 00:00:00 | 2017-02-01 00:00:00 | 2017-03-01 00:00:00 | 2017-04-01 00:00:00 | 2017-05-01 00:00:00 | 2017-06-01 00:00:00 | 2017-07-01 00:00:00 | 2017-08-01 00:00:00 | 2017-09-01 00:00:00 | 2017-10-01 00:00:00 | 2017-11-01 00:00:00 | 2017-12-01 00:00:00 | 2018-01-01 00:00:00 | 2018-02-01 00:00:00 | 2018-03-01 00:00:00 | 2018-04-01 00:00:00 | 2018-05-01 00:00:00 | 2018-06-01 00:00:00 | 2018-07-01 00:00:00 | 2018-08-01 00:00:00 | 2018-09-01 00:00:00 | 2018-10-01 00:00:00 | 2018-11-01 00:00:00 | 2018-12-01 00:00:00 | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-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 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00
 | [NAME] | 2018-06-17 00:00:00 | 2099-12-31 00:00:00 | 20000
 | [NAME] | 2022-07-19 00:00:00 | 2099-12-31 00:00:00 | 25000
 | [NAME] | 2022-07-20 00:00:00 | 2099-12-31 00:00:00 | 40000
 | [NAME] | 2022-07-21 00:00:00 | 2099-12-31 00:00:00 | 50000
 | Hailie Barnes | 2022-07-22 00:00:00 | 2023-08-23 00:00:00 | 15000
 | [NAME] | 2022-07-23 00:00:00 | 2024-09-30 00:00:00 | 200000
 | [NAME] | 2022-07-24 00:00:00 | 2024-10-01 00:00:00 | 35000
 | Gaven Cantu | 2022-07-25 00:00:00 | 2023-12-31 00:00:00 | 43000
 | Jamiya Yoder | 2022-07-26 00:00:00 | 2023-02-28 00:00:00 | 98000
 | Yamilet Buckley | 2021-07-27 00:00:00 | 2099-12-31 00:00:00 | 100611.111111111
 | [NAME] | 2021-07-28 00:00:00 | 2099-12-31 00:00:00 | 109044.444444444
 | [NAME] | 2021-07-29 00:00:00 | 2099-12-31 00:00:00 | 117477.777777778
 | Orion Jacobs | 2021-07-30 00:00:00 | 2099-12-31 00:00:00 | 125911.111111111
 | [NAME] | 2021-07-31 00:00:00 | 2099-12-31 00:00:00 | 134344.444444444
 | Dereon Cantu | 2022-08-01 00:00:00 | 2099-12-31 00:00:00 | 142777.777777778
 | [NAME] | 2022-08-02 00:00:00 | 2099-12-31 00:00:00 | 151211.111111111
 | Heaven Price | 2022-08-03 00:00:00 | 2099-12-31 00:00:00 | 159644.444444444
 | [NAME] | 2022-08-04 00:00:00 | 2099-12-31 00:00:00 | 168077.777777778
 | Emerson Estes | 2022-08-05 00:00:00 | 2099-12-31 00:00:00 | 176511.111111111
 | Yamilet [NAME] | 2022-08-06 00:00:00 | 2024-11-23 00:00:00 | 184944.444444444
 | [NAME] | 2022-08-07 00:00:00 | 2023-01-19 00:00:00 | 193377.777777778
 | [NAME] | 2022-08-08 00:00:00 | 2025-09-01 00:00:00 | 201811.111111111
 | [NAME] | 2022-08-09 00:00:00 | 2099-12-31 00:00:00 | 210244.444444444
 | Claudia Padilla | 2016-08-10 00:00:00 | 2099-12-31 00:00:00 | 218677.777777778
 | Adonis Peck | 2016-08-11 00:00:00 | 2099-12-31 00:00:00 | 227111.111111111
 | [NAME] | 2016-08-12 00:00:00 | 2099-12-31 00:00:00 | 235544.444444444
 | [NAME] | 2016-08-13 00:00:00 | 2099-12-31 00:00:00 | 243977.777777778
 | [NAME] | 2016-08-14 00:00:00 | 2099-12-31 00:00:00 | 252411.111111111
 | [NAME] | 2022-08-15 00:00:00 | 2099-12-31 00:00:00 | 260844.444444444
 | Rowan Cain | 2022-08-16 00:00:00 | 2099-12-31 00:00:00 | 269277.777777778
 | [NAME] | 2022-08-17 00:00:00 | 2099-12-31 00:00:00 | 277711.111111111
 | [NAME] | 2022-08-18 00:00:00 | 2099-12-31 00:00:00 | 286144.444444444