A lease expiration tracker with renewal reminders
The costly lease mistake is noticing the end date two weeks out. Put every lease end in one list and flag it 60 days ahead, which leaves time for a renewal letter and, if they leave, a listing.
The formula
Days left: =LeaseEnd-TODAY(). Status: =IF(LeaseEnd="","Month to month", IF(LeaseEnd<TODAY(),"Ended", IF(LeaseEnd-TODAY()<=60,"Send renewal letter",""))).
Sample leases (as of Nov 7, 2026)
| Door | Tenant | Lease ends | Status |
|---|---|---|---|
| 412 Alder St · A | Jide Okafor | Mar 31, 2027 | Ends in 144 days |
| 412 Alder St · B | Rosa Delgado | Jan 31, 2027 | Ends in 85 days |
| 88 Fenwick Ave | Tom and Ali Brandt | Month to month | Month to month |
| 1907 Larkin Rd · 1 | Kevin Marsh | Jul 31, 2027 | Ends in 266 days |
| 1907 Larkin Rd · 2 | Mei Tanaka | Month to month | Month to month |
Month to month is not "no date"
Leave the end date blank for month-to-month tenants so they show as such, and check your state's notice period before you change rent or end the tenancy.
Skip building it. Doorledger lists every lease with the renewal flag, and puts ones ending soon on the Monday view. The full Doorledger workbook ($29 once, no monthly fee) adds a Monday view, 24 recurring repair jobs, leases, deposits, expenses and a Year summary by Schedule E line.