Library › Sales AI › Revenue operations

Compute renewal notice deadlines with a weekend rule

  • For Revenue operations
  • You practice Setting limits and rules
  • Time about 5 minutes
  • Level Advanced

About this exercise

Compute the last day to give renewal notice for each contract: renewal date minus the notice days. If that day is a Saturday or Sunday, use the Friday before. Write a markdown table with columns Account, Raw deadline (with weekday), Final deadline, sorted by Final deadline from earliest to latest. Use ISO dates. Add one last line "Weekend-adjusted: [accounts]". Under 110 words.

Common mistakes when you ask AI for this

  • Day-count slips. The AI is off by a day when subtracting across months. Try: Add: "Subtract the exact number of days from the renewal date; check month lengths."
  • Moving the wrong direction. The AI moves weekend deadlines to Monday. Try: Add: "A Saturday or Sunday deadline moves back to the Friday before."
  • Sorting by renewal date. The AI keeps the input order. Try: Add: "Sort by Final deadline, earliest first."
  • Missing last line or extras. The AI explains the rule or moves holiday deadlines. Try: Add: "End with Weekend-adjusted: [accounts]; no holiday adjustments; under 110 words."

What a strong prompt includes

  • Names the columns
  • States the weekend rule
  • Sorts
  • ISO dates
  • Closing line

Practice this now ↑

Related exercises