Spreadsheet: 549158d1511475849-rota-planner-with-holidays-copy-of-copy-2-of-rota_33calc
Sheet: 2&3

 |  |  |  | 2017-11-23 00:00:00
 | TO SEE YOUR   ROTA           SIMPLY INSERT THE FIRST DAY OF YOUR NEXT TRIP IN THE RED BOX       THIS WILL CALCULATE A              3 ON 3 OFF        ROTA |  |  | OFFSHORE |  | ONSHORE
 |  |  |  | 2017-01-25 00:00:00 | 2017-02-15 00:00:00 | 2017-02-15 00:00:00 | 2017-03-08 00:00:00
 |  |  |  | 2017-03-08 00:00:00 | 2017-03-29 00:00:00 | 2017-03-29 00:00:00 | 2017-04-19 00:00:00
 |  |  |  | 2017-04-19 00:00:00 | 2017-05-10 00:00:00 | 2017-05-10 00:00:00 | 2017-05-31 00:00:00
 |  |  |  | 2017-05-31 00:00:00 | 2017-06-21 00:00:00 | 2017-06-21 00:00:00 | 2017-07-12 00:00:00
 |  |  |  | 2017-07-12 00:00:00 | 2017-08-02 00:00:00 | 2017-08-02 00:00:00 | 2017-08-23 00:00:00
 |  |  |  | 2017-08-23 00:00:00 | 2017-09-13 00:00:00 | 2017-09-13 00:00:00 | 2017-10-04 00:00:00
 |  |  |  | 2017-10-04 00:00:00 | 2017-10-25 00:00:00 | 2017-10-25 00:00:00 | 2017-11-15 00:00:00
 |  |  |  | 2017-11-15 00:00:00 | 2017-12-06 00:00:00 | 2017-12-06 00:00:00 | 2017-12-27 00:00:00
 |  |  |  | 2017-12-27 00:00:00 | 2018-01-17 00:00:00 | 2018-01-17 00:00:00 | 2018-02-07 00:00:00
 |  |  |  | 2018-02-07 00:00:00 | 2018-02-28 00:00:00 | 2018-02-28 00:00:00 | 2018-03-21 00:00:00
 |  |  |  | 2018-03-21 00:00:00 | 2018-04-11 00:00:00 | 2018-04-11 00:00:00 | 2018-05-02 00:00:00
 |  |  |  | 2018-05-02 00:00:00 | 2018-05-23 00:00:00 | 2018-05-23 00:00:00 | 2018-06-13 00:00:00
 |  |  |  | 2018-06-13 00:00:00 | 2018-07-04 00:00:00 | 2018-07-04 00:00:00 | 2018-07-25 00:00:00
 |  |  |  | 2018-07-25 00:00:00 | 2018-08-15 00:00:00 | 2018-08-15 00:00:00 | 2018-09-05 00:00:00
 | [NAME] Below |  |  | 2018-09-05 00:00:00 | 2018-09-26 00:00:00 | 2018-09-26 00:00:00 | 2018-10-17 00:00:00
 | 2018-03-28 00:00:00 | AWAY |  | 2018-10-17 00:00:00 | 2018-11-07 00:00:00 | 2018-11-07 00:00:00 | 2018-11-28 00:00:00
 | 2018-08-08 00:00:00 | AWAY |  | 2018-11-28 00:00:00 | 2018-12-19 00:00:00 | 2018-12-19 00:00:00 | 2019-01-09 00:00:00
 | 2018-11-28 00:00:00 | AWAY |  | 2019-01-09 00:00:00 | 2019-01-30 00:00:00 | 2019-01-30 00:00:00 | 2019-02-20 00:00:00
 |  |  |  | 2019-02-20 00:00:00 | 2019-03-13 00:00:00 | 2019-03-13 00:00:00 | 2019-04-03 00:00:00
 |  |  |  | 2019-04-03 00:00:00 | 2019-04-24 00:00:00 | 2019-04-24 00:00:00 | 2019-05-15 00:00:00
 |  |  |  | 2019-05-15 00:00:00 | 2019-06-05 00:00:00 | 2019-06-05 00:00:00 | 2019-06-26 00:00:00
 |  |  |  | 2019-06-26 00:00:00 | 2019-07-17 00:00:00 | 2019-07-17 00:00:00 | 2019-08-07 00:00:00
 |  |  |  | 2019-08-07 00:00:00 | 2019-08-28 00:00:00 | 2019-08-28 00:00:00 | 2019-09-18 00:00:00
 |  |  |  | 2019-09-18 00:00:00 | 2019-10-09 00:00:00 | 2019-10-09 00:00:00 | 2019-10-30 00:00:00
 |  |  |  | 2019-10-30 00:00:00 | 2019-11-20 00:00:00 | 2019-11-20 00:00:00 | 2019-12-11 00:00:00
 |  |  |  | 2019-12-11 00:00:00 | 2020-01-01 00:00:00 | 2020-01-01 00:00:00 | 2020-01-22 00:00:00
 |  |  |  | 2020-01-22 00:00:00 | 2020-02-12 00:00:00 | 2020-02-12 00:00:00 | 2020-03-04 00:00:00
 |  |  |  | 2020-03-04 00:00:00 | 2020-03-25 00:00:00 | 2020-03-25 00:00:00 | 2020-04-15 00:00:00
 |  |  |  | 2020-04-15 00:00:00 | 2020-05-06 00:00:00 | 2020-05-06 00:00:00 | 2020-05-27 00:00:00
 |  |  |  | 2020-05-27 00:00:00 | 2020-06-17 00:00:00 | 2020-06-17 00:00:00 | 2020-07-08 00:00:00
 |  |  |  | 2020-07-08 00:00:00 | 2020-07-29 00:00:00 | 2020-07-29 00:00:00 | 2020-08-19 00:00:00
 |  |  |  | 2020-08-19 00:00:00 | 2020-09-09 00:00:00 | 2020-09-09 00:00:00 | 2020-09-30 00:00:00
 |  |  |  | 2020-09-30 00:00:00 | 2020-10-21 00:00:00 | 2020-10-21 00:00:00 | 2020-11-11 00:00:00
 |  |  |  | 2020-11-11 00:00:00 | 2020-12-02 00:00:00 | 2020-12-02 00:00:00 | 2020-12-23 00:00:00
 |  |  |  | 2020-12-23 00:00:00 | 2021-01-13 00:00:00 | 2021-01-13 00:00:00 | 2021-02-03 00:00:00