Sales Cycle Duration Calculator

Calculator inputs

Fill only the dates you track. Missing stages are skipped.

Lead created date *

First contact date

Qualified date

Proposal date

Negotiation date

Close date *

Output unit

Exclude weekends

Use business-day counting

Holidays can be excluded too.

Holidays (comma separated)

Use YYYY-MM-DD format.

Deal value (optional)

Used for value per day only.

Outcome

Won (uncheck for lost)

Stage weight controls

Higher weights emphasize later-stage delays in the weighted cycle time.

Advanced option

Lead → Contact weight

Contact → Qualified weight

Qualified → Proposal weight

Proposal → Negotiation weight

Negotiation → Close weight

Result appears above after you submit.

Example data table

Use this example to understand stage timing patterns.

Deal	Lead Created	First Contact	Qualified	Proposal	Negotiation	Close
A	2026-01-05	2026-01-07	2026-01-12	2026-01-18	2026-01-25	2026-02-02
B	2026-01-10	2026-01-16	2026-01-22	2026-01-30	2026-02-08	2026-02-20
C	2026-02-01	2026-02-02	2026-02-06	2026-02-10	2026-02-12	2026-02-15

Formula used

Sales Cycle Duration is the time from lead creation to close: Cycle = Close Date − Lead Created Date.

If business-day counting is enabled, weekends and listed holidays are removed from the count.

Stage Duration is computed between consecutive stage dates: Stage(i) = Date(i+1) − Date(i).

Weighted Cycle Time highlights late-stage delays: Weighted = Σ(StageDays × StageWeight) ÷ Σ(StageWeight).

How to use this calculator

Enter the lead created date and close date.
Add stage dates you track inside your pipeline.
Choose calendar days or business days counting.
Optionally add holidays to match your working calendar.
Adjust stage weights to stress late-stage risks.
Click calculate and review stage shares and bottleneck.
Export CSV or PDF for dashboards and QBRs.

FAQs

1) What is a sales cycle duration?

It is the time between lead creation and the final close date. It can be tracked in calendar days or business days for a realistic operating view.

2) Why should I exclude weekends and holidays?

Business-day counting reduces distortion when deals sit over non-working days. It helps compare reps, segments, and periods more fairly.

3) Do I need to fill every stage date?

No. The calculator uses only the stages you provide. Missing stage dates are skipped, but you will get fewer stage-level insights.

4) What does the bottleneck stage mean?

The bottleneck is the stage segment with the longest duration. It suggests where follow-ups, enablement, or approvals slow down deal progress.

5) What is weighted cycle time used for?

It emphasizes delays in later stages by applying larger weights. This can better reflect revenue risk when time is consumed near decision points.

6) How do I use the export files?

CSV works well for spreadsheets and dashboards. PDF is useful for sharing a snapshot in reviews, emails, and account planning sessions.

7) Why does value per day show a dash?

It appears only when you enter a deal value and the cycle length is positive. It estimates how much value is generated per day in that deal.