Spreadsheet: 743113d1628234321-calculate-next-expiration-renewal-dates-contract-tracker-sample
Sheet: Sheet1

**columns in gray are auto-calculated**
**rows in red indicate contracts that are drafts or unsigned**
**rows in orange indicate contracts that are about to expire**
**cells in violet indicate contracts that are partially signed**
Counterparty | Contract Type | Status | Agreement Date / Effective Date | Initial Contract Term (months) | Initial Expiration Date | Auto-renew? | [NAME] (months) | Termination Notice Window (days) | Next Expiration Date | Days to Expiration
Company 1 | Master Service Agreement | Fully Signed | 2020-04-20 00:00:00 | 12 |  | Yes | 12 | 30
Company 2 | NDA | Fully Signed | 2020-01-22 00:00:00 | Perpetual |  | No | - | -
Company 3 | NDA | Fully Signed | 2018-05-31 00:00:00 | 12 |  | No | - | 30
Company 4 | NDA | Fully Signed | 2015-08-04 00:00:00 | 24 |  | No | - | -
Company 5 | Client Account Agreement | Fully Signed | 2019-02-01 00:00:00 | 5 |  | No | - | 30
Company 6 | Service Order Form | Fully Signed | 2020-12-07 00:00:00 | 12 |  | Yes | 12 | 30
Company 7 | NDA | Fully Signed | 2016-04-08 00:00:00 | 36 |  | Yes | 36 | 90
Company 8 | Master Service Agreement | N/A | 2020-08-25 00:00:00 | 24 |  | No | - | 45
Company 9 | Order Form | Partially Signed | 2019-03-01 00:00:00 | 12 |  | Yes | 12 | 30
Company 10 | Independent Contractor Agreement | N/A | 2020-04-29 00:00:00 | 6 |  | No | - | 30
Company 11 | Master Service Agreement | Fully Signed | 2017-11-02 00:00:00 | 12 |  | Yes | 8 | 30
Company 12 | Service Order Form | Fully Signed | 2019-03-01 00:00:00 | 12 |  | No | - | 30
Company 13 | NDA | Fully Signed | 2020-08-28 00:00:00 | Perpetual |  | No | -
Company 14 | Master Service Agreement | Fully Signed | 2019-06-10 00:00:00 | 3 |  | Yes | 1 | 30
Company 15 | Master Service Agreement | Fully Signed | 2019-02-27 00:00:00 | 5 |  | No | - | 30
Company 16 | Service Order Form | Fully Signed | 2021-06-14 00:00:00 | 12 |  | Yes | 12 | 30
Company 17 | NDA | Fully Signed | 2019-09-30 00:00:00 | Perpetual |  | No | -
Company 18 | Master Service Agreement | Fully Signed | 2019-12-09 00:00:00 | 7 |  | No | - | 30
Company 19 | Master Service Agreement | Fully Signed | 2020-05-17 00:00:00 | 6 |  | Yes | 1 | 30
Company 20 | Master Service Agreement | Fully Signed | 2020-08-14 00:00:00 | 2 |  | No | - | 30
Company 21 | Master Service Agreement | Fully Signed | 2020-10-29 00:00:00 | 6 |  | No | - | 30
Company 22 | Service Order Form | Fully Signed | 2020-10-29 00:00:00 | 2 |  | Yes | 2 | 30
Company 23 | Service Order Form | Fully Signed | 2015-07-05 00:00:00 | 1 |  | Yes | 1 | 30
Company 24 | Service Order Form | Fully Signed | 2020-08-01 00:00:00 | 12 |  | Yes | 6 | 30
Company 25 | Service Order Form | Fully Signed | 2020-08-01 00:00:00 | 12 |  | Yes | 1 | 30
Company 26 | Service Order Form | Fully Signed | 2020-09-19 00:00:00 | 3 |  | Yes | 3 | 30
Company 27 | Client Account Agreement | Fully Signed | 2020-08-01 00:00:00 | 5 |  | Yes | 5 | 30
Company 28 | Client Account Agreement | Fully Signed | 2018-07-04 00:00:00 | 4 |  | Yes | 4 | 30
Company 29 | Client Account Agreement | Fully Signed | 2020-03-23 00:00:00 | 24 |  | Yes | 12 | 30
Company 30 | Client Account Agreement | Fully Signed | 2020-07-16 00:00:00 | 18 |  | Yes | 12 | 60
Company 31 | Master Service Agreement | Fully Signed | 2020-04-01 00:00:00 | 12 |  | Yes | 12 | 60
Company 32 | Service Order Form | Fully Signed | 2017-01-05 00:00:00 | 1 |  | Yes | 1 | 45
Company 33 | NDA | [NAME] or [NAME] | 2020-05-08 00:00:00 | Perpetual |  | No | -
Company 34 | NDA | Fully Signed | 2020-06-24 00:00:00 |  |  | No | -
Company 35 | Client Account Agreement | Fully Signed | 2021-04-01 00:00:00 | 12 |  | Yes | 6 | 30
Company 36 | Master Service Agreement | Fully Signed | 2019-04-10 00:00:00 | 13 |  | Yes | 7 | 60