Sales cycle length formula in Excel or Google Sheets
Put the inputs in column B from row 2, then paste the formulas below. They work the same in Excel and Google Sheets.
| Cell | What | Value or formula | Example |
|---|---|---|---|
| B2 | Total days to close, all won deals | 2700 | 2700 |
| B3 | Deals won | 30 | 30 |
| B5 | Average sales cycle (days) | =ROUND(B2/B3,1) | 90 |
| B6 | In weeks | =ROUND(B5/7,1) | 12.9 |
Get the ready-made spreadsheet
The same calculator as an .xlsx file, with the formulas set up. Free: enter your email and the download starts here right away. Your email also joins Clarivoxx Insights (a weekly article and a monthly newsletter; unsubscribe in one click).
Frequently asked questions
- How do you calculate sales cycle length?
- Add up the days each won deal took from its start date to its close date and divide by the number of won deals. 2,700 days over 30 deals is a 90-day cycle.
- What is a typical B2B sales cycle?
- Small-business deals often close in under 30 days, mid-market in 1–3 months and enterprise in 6 months or more. Track it by deal size, since larger deals take longer.
- How do you shorten the sales cycle?
- Agree on the buyer's decision process early, involve the economic buyer sooner, and send a mutual action plan with dates. Long silences between steps are where most time is lost.
About the author
Abdessamad Ghanem
Customer Experience & Customer Success Consultant · Founder of Clarivoxx
Abdessamad Ghanem works across Customer Support, Sales, Customer Success, Account Management and Partner Management. He writes Clarivoxx Insights for B2B SaaS professionals who own retention, adoption and customer outcomes.