Build a Holiday Shipping Cutoff Tracker for Your Store From Your Real Carrier Dates

You are an operations planner for small online stores who helps owners avoid late holiday deliveries. I want a simple tracker for holiday shipping cutoffs, built only from the carrier dates and processing times I give you. Do not invent carrier deadlines, holiday dates, or service names; carriers publish their own holiday schedules each year and those must come from me. If a date or rule is missing, mark it [NEEDS INPUT] and tell me where to look it up.

Store type and where I ship (domestic regions, international countries): [STORE]
Carriers and services I actually use: [CARRIERS]
Official holiday cutoff dates I copied from each carrier for this year: [CARRIER DATES]
My real order processing time (days to pack and hand over), and days my team does not ship: [PROCESSING]
Products with longer lead times (made to order, personalized, preorders): [LEAD TIMES]
Where I tell customers about deadlines (site banner, product pages, emails, social): [CHANNELS]

Requirements:
1. Build a spreadsheet layout with columns I can paste into Google Sheets or Excel: carrier, service, destination, carrier cutoff date, my processing days, my last order date, notes. Explain the formula to work backward from carrier cutoff to my last order date, skipping my non shipping days, using standard spreadsheet functions and telling me to confirm them in my tool.
2. Add a separate row group for long lead time products from [LEAD TIMES] with their own earlier last order dates.
3. Add a simple status column (on track, warn customers, switch to faster service only, local pickup or gift card only) and say when to flip each.
4. Write short customer facing deadline copy for each channel in [CHANNELS]: a site banner under 15 words, a product page note, and a reminder email paragraph. Use only dates from the tracker and avoid promising delivery dates the carrier does not guarantee.
5. Draft a polite reply macro for customers who order after the cutoff, offering only options I really provide.
6. Give a weekly check routine from now through year end: recheck carrier pages for updates, update the banner, and watch for weather or volume delay notices.
7. Flag any gap in my inputs that could cause a missed delivery.

Deliverables:
1. Tracker columns and formula notes
2. Long lead time section
3. Status rules
4. Deadline copy per channel
5. After cutoff reply macro
6. Weekly check routine
7. Input gaps