Generate a Days Until Renewal Formula for Google Sheets
Use this prompt to generate a Google Sheets formula that automatically calculates how many days remain until each client's contract renews, updating dynamically each day without manual date math.
The Prompt
I have a Google Sheet where column D contains contract renewal dates (formatted as dates). Starting in row 2, write a formula for column E that calculates the number of days between today and the renewal date. If the renewal date has already passed, show a negative number.
From the guide
Using AI to build a simple contract renewal reminder system from your existing client list so nothing slips through without a follow-up →Related Prompts
Add a Vendor or Client Introduction Task to Onboarding
Use this as a follow-up prompt when the AI has omitted the vendor or client introduction step, which is commonly left out of AI-generated onboarding checklists because large-company training data handles it differently.
Rewrite a Corporate Onboarding Checklist for Small Business
Use this as a follow-up prompt if the generated checklist feels too generic or reads like a large-company HR template, to push the AI toward simpler, more actionable language suited to a small business.
Restructure a Flat Onboarding List Into Five Phases
Use this as a correction prompt in the same conversation if the AI returns a flat list instead of the five-phase structure (Before Day 1, Day 1, Days 2–5, End-of-Week-1 Check-in, Days 8–30).
Find Documentation Gaps Before a New Hire Starts
Use this as a follow-up prompt in the same conversation to identify gaps in your existing documentation before the new hire's first day, so you can prepare materials they'll need rather than fielding repeated questions.