One calendar. Two ways to work.

What the coverage means

Free in 2026 means 2026–2027, then 2027–2028 after the 1 January rollover in the spreadsheet’s timezone. It does not include custom ranges. Pro expands the year window to 2000–2035, subject to source coverage; it does not make unpublished calendars complete.

Business-day formulas: years with published calendars; holiday lists: 2000–2035 on Pro. The same completeness checks apply on Free. Some countries have no complete year under the current source. Check data availability before choosing a plan.

2 seats, tied to spreadsheet owners

One Pro subscription includes 2 seats for two independent Google accounts, such as work and household accounts. Activate one seat in each spreadsheet owner’s account. A third activation is refused until a seat is released. Deactivate in the add-on’s sidebar releases that account’s seat; if you no longer have access to the account, licence recovery releases one using the Paddle receipt’s transaction ID.

• A Pro owner gives every editor Pro results in that spreadsheet.
• A Pro editor in a Free owner’s spreadsheet gets Free results. Ask the owner to activate, or make a copy owned by the Pro account.
• A copied spreadsheet uses its new owner’s tier.

How fast a change reaches your cells

1. Server entitlement

   A refund revokes entitlement at the payment authority immediately. Our licence service follows Paddle within the webhook delivery delay plus up to a minute of cache propagation. A fresh verification reads Paddle directly with no cache. If a webhook is never delivered at all, the service re-reads Paddle within 6 hours and revokes then.

2. Stored add-on state

   The owner’s stored state refreshes once a day through a trigger installed at activation, and immediately on Recalculate Holiday Formulas, which performs a fresh verification. Google schedules the daily run inside a chosen hour, so consecutive runs sit around 24 hours apart rather than exactly.

3. Displayed cells

   Displayed cells change only when they execute again: on argument change, on Recalculate, or when Sheets re-executes them. A positive verification cached by a formula is honoured for at most 6 hours, and a negative one for at most 5 minutes — so a renewal restores Pro within 5 minutes, even in a spreadsheet whose owner has it closed.

4. The worst case, stated plainly

   Those layers stack, and the daily refresh is the slow one. A refund reaches our service within about a minute, but the spreadsheet’s stored state only changes when the daily refresh runs, so a cell that is not recalculated in the meantime can keep showing Pro for up to about a day. Recalculate Holiday Formulas ends that immediately. We would rather publish the real number than imply it does not exist.

These rules also apply to subscription expiry and the Free-window rollover on 1 January. Previously calculated values can remain visible until re-execution; the sidebar shows a rollover banner when opened.

Evaluations and Google quotas

There is no product cap on formula evaluations on either plan. “Unlimited” remains subject to Google’s Apps Script per-user execution limits, service quotas, and the 30-second custom-function runtime limit. Large workloads should use one range formula instead of a separate formula in every row.

Billing, cancellation and refunds

Paddle is the merchant of record and processes recurring yearly or monthly subscriptions. Cancellation stops renewal; Pro continues until the paid-through date. A failed renewal or paused subscription does not extend paid coverage. Approved refunds revoke entitlement under the refresh guarantees above.

A 14-day refund window applies. Review the terms for owner-based licensing.