IT vendors and contracts

Auto-renewal notice periods: how to track them and never miss a date

Published 20 October 2026 · 6 min read

To never miss an auto-renewal date, compute for each contract the last day on which notice can still be given, keep that date in a register, and act on two reminders. The contractual deadline is the end date minus the notice period: =EDATE(End,-Months) when the notice is in months, =End-Days when it is in days. Subtract your own dispatch margin, move the result back to a working day, and review the register monthly: at 90 days before the deadline, decide whether to renew, renegotiate, re-tender or exit; at 30 days, the notice letter must be ready. If the deadline passes without notice, roll the end date forward by the renewal term and start again.

The auto-renewal trap

An auto-renewal (tacit renewal, evergreen) clause renews the contract for a new term unless one party gives notice before a date that falls weeks or months before the end date. The end date is easy to remember; the notice deadline is not, and it is the one that decides. Add a change of owner, a summer break or a letter that needs a signature, and the contract renews for another term on its existing terms, sometimes for the full initial duration, depending on the clause.

Reading the clause: term, notice, form

Item	What to read	Register column
Term	Start date, end date of the current term	End date
Renewal	Automatic or by written agreement; length of each renewal (12 months, same as initial term…)	Renewal type, renewal term
Notice period	Length and unit: months, calendar days or business days	Notice period, unit
Reference point	Before the end date, before each anniversary, before a fixed date	End date (store the next anniversary)
Form	Method (registered mail, courier, email to a notice address), recipient, address	Notice method
What counts	Dispatch or receipt of the notice	Comment

The last two lines decide whether your notice is valid, and they depend on the contract and its governing law. When the stakes are high, have a lawyer read the clause once and record the answer in the register; this article covers the date computation, not the legal effect of a notice.

The spreadsheet formula

With the end date in G2, the notice period in H2 and its unit in I2, and a named range Holidays:

Contractual deadline: =IF(I2="months",EDATE(G2,-H2),G2-H2). Microsoft documents EDATE(start_date, months) and states that a negative value yields a past date. If the target month has no such day, EDATE returns its last day: one month before 31 March 2027 gives 28 February 2027.
Notice in business days: =WORKDAY(G2,-H2,Holidays); WORKDAY(start_date, days, [holidays]) skips weekends and listed holidays.
Internal deadline, with a dispatch margin in Settings and moved back to a working day: =WORKDAY(J2-Settings!$B$5+1,-1,Holidays), where J2 is the contractual deadline.
Days remaining: =K2-Settings!$B$2, where the Settings cell holds the as-of date of the review.
Next end date after a renewal: =EDATE(G2,L2), with the renewal term in months in L2, entered once the deadline has passed without notice.

The register and reminders

One row per contract, the columns from the table above, the computed dates, and an alert:

=IF(Settings!$B$2>G2,"Expired: out of contract",IF(Settings!$B$2>K2,"Notice deadline missed",IF(K2-Settings!$B$2<=30,"Notice due soon",IF(K2-Settings!$B$2<=90,"Renegotiate","OK"))))

The 90 and 30 days are working choices, not rules: set them in Settings so that a critical contract leaves enough time for a tender. Then three habits: a monthly review sorted by days remaining, with an owner and a next action for every alert; calendar reminders for the owner and the buyer at the 90-day and 30-day marks; and a named deputy, so that a departure does not orphan a contract. The full set of register columns is described in the IT contract register template.

Preparing the notice or the renegotiation

At 90 days: collect the last twelve months of service readings and spend, list what you want changed (price, service levels, exit terms), and decide. A re-tender needs more time than a renegotiation, so start earlier for critical contracts.
At 30 days: the notice letter is drafted, approved and ready to send by the method the contract specifies, ideally one that proves receipt.
On sending: file the proof, record the date in the register, set the status to "Notice given", and plan the exit or the new contract.

Sending notice does not prevent a new agreement with the same vendor; it means you negotiate without the renewal running on its own. A renewal also moves next year's budget: reflect the new price in the forecast, as in the IT budget template.

Example (fictitious data)

As-of date 20 October 2026, dispatch margin 10 days, thresholds 90 and 30 days, no holidays in the period.

Contract	End date	Notice	Contractual deadline	Internal deadline	Days remaining	Alert
Cloud backup	2027-01-31	2 months	2026-11-30	2026-11-20	31	Renegotiate
Telecom lines	2027-03-31	90 days	2026-12-31	2026-12-21	62	Renegotiate
Software licences	2026-12-15	1 month	2026-11-15	2026-11-05	16	Notice due soon
Printer fleet	2026-11-30	3 months	2026-08-30	2026-08-20	−61	Notice deadline missed
Monitoring tool	2027-09-30	6 months	2027-03-30	2027-03-19	150	OK

Two rows show why the internal deadline exists. The licence deadline falls on a Sunday; the margin brings it to a Thursday. The monitoring tool's margin lands on a Saturday, and WORKDAY moves it to Friday 19 March. The printer fleet will renew under its clause: with a 12-month renewal term, its new end date is 30 November 2027 and its next contractual deadline 30 August 2027.

What the tool does for you

The IT Vendor and Contract Management Kit is a nine-sheet Excel workbook with native formulas and no macros, for Excel 2016 and later or Google Sheets. Its Contract register computes, for each contract, the notice deadline (end date minus a notice period in months, with EDATE), the days to the end date and to the deadline, and the alert: Renegotiate, Notice due soon, Notice deadline missed, Expired: out of contract, Prepare exit. The as-of date and the thresholds (90 days and 30 days by default) sit in Settings. For clauses in days or business days, use the formulas above. The Budget sheet adds a 24-month renewal schedule, the Dashboard lists the five most urgent contracts, and the Word templates include a notice of non-renewal or termination letter in two versions. The 22-page guide sets out a reverse calendar for critical contracts. Fictitious data set, unlimited use within the licensed company, 12 months of updates.

IT Vendor and Contract Management Kit: $290 excl. tax

Launch code LANCEMENT: 30% off, for the first 20 orders or until 30 November 2026.

FAQ

Does notice count when sent or when received?

The contract and its governing law decide. Plan for receipt before the deadline and use a method that proves it; the dispatch margin is there for that.

The deadline has passed. What now?

The contract renews on its own terms. Enter the new end date, set the next deadline, and check whether the contract offers termination for convenience or room for a negotiated early exit.

As-of date or TODAY()?

An as-of date. TODAY() changes each time the file opens; a fixed as-of date makes each monthly review reproducible and easy to file with its decisions.