Give an AI assistant the signed contract and every addendum, ask for each deadline with its trigger, day count, clause and page, then check every row against the paper before anything reaches a calendar. The extraction takes minutes. The checking is the real job, because assistants miscount days, apply superseded terms and skip items.
Treat the assistant as a second reader, not the record. The signed contract controls, and the table it produces is a draft until you have checked each line. Forms differ in how they count days and handle weekends, so the example below uses invented terms; read your own form's definitions. This is not legal advice, and questions about what a missed date means go to your broker or a real estate lawyer.
Feed it the signed set, in date order, with handwriting flagged
Most extraction errors start before the prompt, with the wrong documents. Gather the executed contract, every counter-offer, every addendum and any signed extension, and name the files in date order: 01-offer, 02-counter-1, 03-addendum-A. Later documents override earlier ones where they conflict, and the assistant can only apply that rule if it knows which came later. A scan of the first offer sitting in the same folder as the final signed version is exactly how a superseded term gets extracted.
Then think about what the file contains. A purchase package carries names, addresses, bank details for the earnest money and sometimes identity numbers. The assistant needs the dates, parties and clauses, not the account numbers, so blank those out first. Use the tool your brokerage has approved: business plans such as ChatGPT Business, Claude Team, Gemini in Workspace and Microsoft 365 Copilot don't train on business content by default, whereas consumer plans put the choice in a privacy setting. The brokerage rules tutorial for emails, disclosures and contracts covers what offices usually allow.
File size is rarely the obstacle. A 40-page package sits far below the page limits of the main assistants (Claude, for instance, reads PDFs of up to 1,000 pages, with visual layout supported up to 100 pages). Scan quality is the obstacle. Handwritten changes initialled in a margin, a struck-through date and a stamped "received" mark are the items most likely to be missed or misread. So ask the assistant, as the first step, to list every page it cannot read cleanly and every handwritten or typed-over change it sees, and look at those pages yourself before you read anything else it says.

The Complete Excel Course with AI Integration
From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.
By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner
Buy nowAn extraction prompt that shows its counting
The prompt below asks for rules as well as dates. A date alone gives you nothing to check; a date with its trigger, counting rule, clause and the assistant's own day-by-day count lets you see where a wrong assumption crept in.
You are helping a real estate agent turn a signed residential purchase contract
into a deadline sheet. The attached documents are the only source. They are in
date order: [01-offer, 02-counter-1, 03-addendum-A]. Later documents override
earlier ones where they conflict.
Step 1. List every document you were given with its page count. Name any page
that is blank, unreadable or skewed, and any handwriting or initials you are not
certain you read correctly.
Step 2. Find every date, period, deadline and condition: effective date, earnest
money, disclosures, inspection, appraisal, financing, title and survey, HOA or
condo documents, sale of the buyer's home, repairs, walk-through, closing,
possession, extensions, and the rules for giving notice.
Step 3. Give one table row per item with these columns: No. | Item | Who must act
| Trigger event | Period exactly as written | Day-counting rule as written | Time
of day | Document, clause and page | Exact words (25 words at most) | Amended or
superseded by | Confidence (High/Medium/Low) and why.
Step 4. Where the trigger has already happened, calculate the date and show the
count one day per line, stating which days you treated as non-business days.
Quote the contract's definitions of "day", "business day" and "effective date".
Step 5. List anything you looked for and did not find, any conflict between
documents, and any deadline whose trigger has not happened yet.
Do not interpret legal effect, say what happens if a date is missed, or advise
whether to waive anything.
Each instruction is there because of a failure it prevents. "Exact words, 25 at most" stops paraphrase, which is where a "within" quietly becomes an "after". "Amended or superseded by" forces the assistant to compare documents instead of reading the first one it meets. The count-by-line requirement turns a hidden assumption, such as treating a public holiday as a working day, into something visible. The last line keeps it out of territory where a confident-sounding answer could mislead you.
One purchase at $485,000, from contract terms to verified dates
Everything in this example is invented, including the clause numbers, which are there to show the format. A buyer and seller reach mutual acceptance at 4:15 p.m. on Tuesday 10 November 2026 on a $485,000 purchase. The form defines a business day as any day except a Saturday, Sunday or public holiday, and says the day of acceptance is not counted. A deadline that falls on a weekend or holiday moves to the next business day. Times are local to the property. A counter-offer signed that same afternoon replaced the original offer's 30-day financing period with 25 days. Say a public holiday falls on Wednesday 11 November.
The table is the finished deliverable after verification: the contingencies and deadlines the agent will calendar, with the dates worked out and checked.
| Item | Clock as written | Verified date | Who acts | Where |
|---|---|---|---|---|
| Earnest money, $10,000 | 3 business days after acceptance | Mon 16 Nov | Buyer pays the escrow holder | Contract §3, p.2 |
| HOA documents delivered | 5 days after acceptance | Mon 16 Nov (Sun 15 Nov rolls forward) | Seller | Contract §6, p.3 |
| Inspection objections | 10 days after acceptance, by 5:00 p.m. | Fri 20 Nov, 5:00 p.m. | Buyer gives written notice | Contract §7, p.3 |
| Seller's reply to objections | 3 days after the notice is delivered | Set on delivery: Mon 23 Nov if delivered Fri 20 Nov | Seller | Contract §7.2, p.3 |
| Appraisal contingency | 21 days after acceptance | Tue 1 Dec | Buyer, through the lender | Contract §8, p.4 |
| Financing contingency | 25 days after acceptance (replaces 30) | Mon 7 Dec (Sat 5 Dec rolls forward) | Buyer, through the lender | Counter-offer 1, item 4 |
| Final walk-through | Within 2 days before closing | Window opens Wed 16 Dec | Buyer and agent | Contract §11, p.5 |
| Closing and possession | Fixed date | Fri 18 Dec | Both sides | Contract §2, p.1 |
Notice what the table does not say: what happens if a date passes. For each contingency, add one more column headed "If the date passes", filled with the contract's own words, the clause and the page, never your paraphrase. Some contracts end the right, some leave it open until someone acts, and some need a notice first. If you can't find the wording, that is a question for your broker, and the empty cell is the reminder to ask.
Look also at the calendar this produces. Monday 16 November carries two deadlines, earnest money and the HOA documents, and it is the first normal working day after a holiday. A sensible agent sets reminders for the Thursday and Friday before it, and tells the client early that the transfer needs to be arranged that week, whatever the deadline says. Dates that cluster are worth spotting while the sheet is still a table, because a calendar shows them one at a time.
Where the first pass went wrong, and what caught each error
Here is what an assistant might plausibly return on a first pass through that contract, an invented run that shows the kinds of slips to expect. Three of the eight rows came out right (the seller's reply, the appraisal date and the closing date). The other five needed attention, and the last column shows how each was caught.
| Item | Assistant said | Signed contract says | What caught it |
|---|---|---|---|
| Earnest money | Fri 13 Nov | Mon 16 Nov, because 11 Nov is a public holiday and the business-day definition excludes it | Its day-by-day count listed 11 Nov as day 1 |
| HOA documents | Sun 15 Nov | Mon 16 Nov, because weekend deadlines roll forward | Checking the weekday of every date |
| Inspection objections | Fri 20 Nov, all day | Fri 20 Nov, 5:00 p.m. | The time-of-day column was empty |
| Financing contingency | Thu 10 Dec | Mon 7 Dec, because Counter-offer 1 says 25 days | The "amended by" column was blank; the 30 days came from the original offer |
| Final walk-through | Not listed | Within 2 days before closing, §11 | The "anything you did not find" step and the brokerage checklist |
The financing row is the dangerous one. The assistant's date was three days later than the real one, so an agent who trusted the calendar would have told the buyer there was time left when the contingency had ended. The earnest-money date errs on the early side, which costs nothing, and the HOA date concerns a seller's task, but both still produce a wrong calendar, and a calendar with wrong entries trains everybody to ignore it. The inspection row shows a subtler fault: the date was right and the entry was still wrong, because an all-day event invites a 6 p.m. email that arrives an hour late.
All five errors left a visible fingerprint. The first was caught by the day count the prompt demanded, the second by the agent's habit of checking the weekday of every date, and the third by the empty time column. A blank "amended by" cell exposed the fourth, and the question about what was missing exposed the fifth. That is the reason to ask for structure: a paragraph summary hides these faults, while a table with required columns turns them into gaps you can see.
Recompute the dates in a spreadsheet, not in your head
The checking step that catches the most is an independent calculation. Put the acceptance date in a cell, type the public holidays for the property's location into a short list, and let the spreadsheet count. Type the holiday list yourself. An assistant's holiday list changes by place and by year, and a wrong one is invisible until a deadline slips.
B1 = acceptance date (10 Nov 2026) E2:E10 = public holidays you typed
Calendar days: =B1+10
Business days: =WORKDAY(B1,3,E2:E10)
Roll forward if needed: =WORKDAY(B1+25-1,1,E2:E10)
Weekday check: =TEXT(C5,"dddd")
Microsoft's documentation describes WORKDAY as skipping weekends and any holidays you list, and Google Sheets has a function of the same name. It does not count the start date, which matches a form that says the day of acceptance is not counted. If your form counts the acceptance day as day 1, subtract a day from the formula's input, and write that choice in a note beside the cell. The roll-forward formula takes the day before the deadline and moves one business day on, so a Saturday 5 December becomes Monday 7 December while a Friday stays put.
A quick sum shows the method on the earnest money. =WORKDAY(B1,3,E2:E10) with 11 November in the holiday list returns Monday 16 November; with the list empty it returns Friday 13 November. The two answers are the gap between the assistant's first pass and the contract. When the assistant's date and your formula disagree, do not pick the one you prefer. Open the definitions page of the contract, read what counts as a business day, and let the paper decide.
The ten-minute verification pass
Verification is quicker when it follows the same order every time. Print the table or put it beside the signed set on a second screen, and work down this list.
- Compare the documents the assistant listed in step 1 with the set you hold, page count for page count. A missing addendum is the commonest root cause.
- Open the cited page for every row, read the exact words against the contract, and tick or correct the row. Do not tick a row from memory.
- Read the definitions page and compare it with what the assistant quoted for "day", "business day" and "effective date".
- Recompute every date with the spreadsheet formulas and compare. Investigate every difference, even a single day.
- Check each time of day and each delivery method: who must receive the notice, in what form, and where it must go.
- Read the "amended or superseded by" column, then read the newest document first to confirm nothing older has crept in.
- Ask: "Which deadlines could appear in a contract like this that are not on your list?" and compare the answer with your brokerage's own checklist.
- Write "Checked against the signed copy by [initials], [date]" at the top of the sheet.
Most files need about ten minutes, and a file with several addenda takes longer. A sheet that has been through all eight steps is reliable enough to build a calendar on. A sheet that has skipped steps 2 and 4 is only an AI summary.
From verified sheet to calendar entries
Name entries so they survive a crowded calendar: a short property label, who acts, what, and the time. Put the clause and page in the description so whoever opens the entry can find the source in seconds, and add a second reminder one business day before the deadline as your own buffer. These filled-in entries come from the sample deal.
| Entry title | When | Reminders | Description |
|---|---|---|---|
| [12 Oak] BUYER: earnest money $10,000 to escrow | Mon 16 Nov, all day (contract gives no time) | 3 days, 1 day, morning of | §3, p.2: 3 business days; 11 Nov excluded as a public holiday. Checked against signed copy: [initials], [date] |
| [12 Oak] BUYER: inspection objections due 5:00 pm | Fri 20 Nov, 17:00 | 3 days, 1 day, 3 hours | §7, p.3. Written notice; delivery rules §9, p.4. Own target: send Thu 19 Nov |
| [12 Oak] BUYER: financing contingency ends | Mon 7 Dec, all day | 7 days, 3 days, 1 day | Counter-offer 1, item 4: 25 days, replaces 30. Own target: lender's written commitment by Fri 4 Dec |
| TENTATIVE [12 Oak] SELLER: reply to objections | No date yet | None until notice is delivered | §7.2, p.3: 3 days after delivery. Add the date when the notice goes out, then remove TENTATIVE |
The tentative entry matters. A deadline whose trigger has not happened has no date, and a guessed date on a calendar is worse than an empty one. Label it, leave the date off or pencil one in clearly, and complete it when the notice goes out.
If you would rather import than type, Google Calendar accepts CSV files with English column headings, where only Subject and Start Date are required, and as of November 2026 its help page gives a month-first date format (its example is 05/30/2020). Repeating events may arrive as separate one-off entries rather than a series. Add Start Time and Description columns for the rest. Three consequences follow. A spreadsheet in a day-first setting needs its dates converted before export, or an entry for 7 December could land on 12 July. Import one test row into a spare calendar before the whole sheet. And if you use another calendar, check its import help for the file types it accepts.
Give each deal its own calendar, shared with whoever coordinates the transaction. Clients usually need something simpler than a calendar, and a short message with the verified dates in plain words does the job:
"Hi [first name], here are the key dates in your contract, checked against the signed copy: earnest money to the escrow holder by Monday 16 November; inspection objections in writing by 5:00 p.m. on Friday 20 November; financing contingency date Monday 7 December; closing Friday 18 December. Please tell me straight away if any of this differs from what you remember, and call me before any date if you're unsure what is needed."
Questions to hand to your broker, not to the assistant
An assistant is fluent enough to answer questions it has no business answering. Whether a text message counts as written notice, whether a client should waive a contingency, what follows a missed date, and whether a clause making time "of the essence" makes a given date strict: all of these depend on the contract, the form and the rules where the property sits. Add one line to the Project instructions: "If I ask a legal question, don't answer it. List the exact clauses involved and the questions I should take to my broker."
That instruction turns the assistant's confidence into something useful. After the sample deal, the list it returned looked something like this (illustrative wording, like the rest of the example):
"1. §9 says notice may be given 'by email to the address in §20'. Does the buyer agent's address count, or only the buyer's? 2. §7 says the inspection period ends at 5:00 p.m. 'local time'. Which time zone applies if the buyer is travelling? 3. Counter-offer 1 reduces the financing period but does not mention the appraisal period. Does the appraisal period stay at 21 days? 4. §14 moves weekend deadlines to the next business day. Does that apply to the walk-through window as well as to the contingency dates?"
Those are good questions, and each one stops an agent from guessing. The same pattern helps in other files, and the transaction coordinator tutorial shows which other file-keeping jobs are worth handing to AI at all. For inspection findings, the inspection report summary tutorial covers the repair-request side that follows the objection deadline in the sample deal.
Re-running the sheet when an addendum arrives
Deadlines change during a deal, and a calendar built once goes stale. Treat every new signed document as a trigger to re-run the whole process, not to patch one entry. Suppose Addendum B, signed on Tuesday 17 November, extends the inspection period by 2 days. The period now ends 12 days after acceptance, which is Sunday 22 November, so under the form's rolling rule it moves to Monday 23 November at 5:00 p.m. If the buyer's notice goes out that Monday, the seller's three days run to Thursday 26 November, a public holiday in this example, which rolls to Friday 27 November. One extension moved two dates, and the seller-reply entry changed from tentative to a real date.
To catch that kind of cascade, paste the previous table into the assistant along with the full set of documents and ask: "Here is the deadline table from the previous version. Compare it with the documents, now including Addendum B, and list every row that changes, with the old and new date and the clause that caused the change." Then verify the changes with the same ten-minute pass, update the calendar entries, and add a line to the deal's notes: "v3, after Addendum B, checked [initials], [date]". Keep every version of the table in the deal file. If anyone asks later why a date was in the calendar, the version history answers the question.
The tutorial on tracking contract renewals and deadlines applies the same extract-verify-calendar loop to business contracts, which is useful if you also manage listing agreements or leases. For the broader question of what an assistant can do inside a calendar, see whether AI can manage your calendar before you let one create events on your behalf.
Questions agents ask before trusting AI with contract dates
Can AI tell me whether a contingency has been waived?
It can quote the clause and list any signed waiver it finds, which is useful, but it cannot decide what a waiver, a late notice or a missed date means for your client. That is a legal question for your broker or a real estate lawyer. Ask the assistant to list the exact words and the documents involved, then take them to the person who can advise.
Should the assistant add the dates to my calendar directly?
Not before the sheet is verified. Some assistants can connect to a calendar and create events, but a wrong event looks exactly like a right one and gets trusted. Verify the table against the signed contract first, then create the entries yourself or import a file you have checked, starting with a single test row.
What if the contract does not say how to count days?
Do not let the assistant pick a convention for you. Check the form's definitions section and any note from the form's publisher, then ask your broker how your office counts. Until you have an answer, calendar the earliest plausible date as a tentative reminder and label it so nobody treats it as settled.
What should I tell clients about using AI on their contract?
Follow your brokerage's policy on client documents first, because some offices restrict uploads. Where it is allowed, tell clients that the dates they receive come from their signed contract and were checked by you personally. The assistant is an internal drafting step, and the person responsible for the dates is you.
Further reads
- AI for Real Estate Attorneys: Closing Checklists and Title Review — How the closing side checks the same dates.
- Escrow Instructions With AI: Draft From the Contract, Then Check — See how escrow instructions are drafted from the contract.
- AI for Real Estate Brokers: Compliance File Review Step by Step — What a broker checks in a transaction file afterwards.
- AI Tools for Real Estate Brokers: From Transactions to Agent Support — Tools a brokerage can run behind every deal file.
- AI Due Diligence on Real Estate: Read Leases, Surveys, Searches — Due diligence reading for an investor's purchase.
- AI for Escrow Officers: Inbox Triage and Closing Checklists — How the escrow side triages mail and tracks closing steps.
- Title Insurance AI: Pick a First Pilot and Price It for an Agency — Choose document intake or status updates as one first pilot, price it per closed file with a break-even table and judge it on a six-week scorecard.
- AI Automations for Real Estate Wholesalers: Sourcing to Contracts — A step-by-step map of what to automate in a wholesaling business, where a person must stay in the loop, and the consent and disclosure rules.
- AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.
Sources: Google Calendar's CSV import help page, Claude's file-upload help page, the vendors' pricing and privacy pages for business AI plans, and the WORKDAY function pages for Excel and Google Sheets (all checked November 2026). The contract terms, clauses and dates in the examples are invented for illustration.