Calculate Sales Cycle Length
Result—
Formula
Total Days to Close Deals / Number of Closed DealsExcel formula
=IFERROR(B2/C2,0)
Power BI DAX measure
Sales Cycle Length =
DIVIDE(
[Total Days to Close Deals],
[Closed Deals]
)
Enter your values to calculate Sales Cycle Length. Use the formula and examples below for Excel, Google Sheets, Power BI, and dashboards.
Useful learning resources related to this page. As an Amazon Associate, this site may earn from qualifying purchases at no extra cost to you.
Total Days to Close Deals / Number of Closed Deals=IFERROR(B2/C2,0)
Sales Cycle Length =
DIVIDE(
[Total Days to Close Deals],
[Closed Deals]
)