How to Calculate Days Between Two Dates in monday.com (and Visualize It)

How to calculate days between two dates in monday.com with calendar and calculator icons, 2025 example

Tracking the number of days between two events — like a demo and a sign-up — is more than just a metric. It’s a window into your conversion speed, customer interest, and team performance.

In this article, we’ll show you how to calculate the number of days between two dates in monday.com, and how to take it one step further with visual reports using the Time in Status for monday.com app.

This use case was inspired by a real user in the community looking to:

Calculate how many days pass between a demo and a sign-up.
Show this time visually — like a chart or a battery-style indicator.

Let’s break it down step by step.

⏳ Step 1: Calculating Time Between Two Dates (Native Formula)

monday.com has a built-in Formula column that lets you calculate the number of days between two date columns.

If you have two columns:

Demo Date
Sign-Up Date

You can use the formula:

This will return the number of days it took for someone to sign up after the demo.

📝 Tip: If Sign-Up happens before the Demo, the result will be negative. You can add ABS() to keep it positive.

But that’s just the beginning.

📊 Step 2: Visualizing the Time Gap (The Challenge)

By default, monday.com formulas can’t be charted or easily visualized — unless you:

Mirror the value
Create complicated dashboard hacks
Use third-party tools

That’s where Time in Status for monday.com can help.

✅ A Better Solution: Time in Status (Advanced Date Tracking & Visualization)

With Time in Status for monday.com, you can go far beyond formulas. It allows you to:

Track time between any two statuses or actions
Display the result in dashboards, tables, and charts
Apply working calendars (e.g. business days only)
Filter by person, group, board, or period

Time in Status for monday.com displayed as board view and integration, showing how long tasks stay in each status within workflows — Monitor status durations directly on monday.com boards or use as an integration to analyze task progress and workflow efficiency.

Let’s say you move tasks from “Demo Scheduled” to “Signed Up” status. Time in Status will show you how many days each item spent in between — and visualize it.

🖼️ Example: See Time Between Demo and Sign-Up in a Bar Chart

With Time in Status:

The app calculates the exact number of days per item or any status group (Demo Scheduled” → “Signed Up)
You can then view results as:
- 📈 Bar chart by person
- 📉 Trends over time
- 📊 Average days per lead

Different chart types in Time in Status for monday.com: Pie, Bar, and Area Chart showing transition counts — Choose between Pie, Bar, and Area charts to analyze how often items change statuses in your monday.com workflow using the Time in Status app

This gives you a real-time, zoomed-out view of how long it takes for people to convert — across the entire pipeline.

🔍 Bonus: Compare Conversion Speed Across Teams or Products

With filters and groups, you can compare:

How fast different salespeople convert
Whether some lead sources sign up quicker than others
Seasonal or monthly trends in sign-up speed

📥 Export & Share Your Insights

Time in Status also allows you to:

Export reports to Excel or CSV
Share visuals in weekly check-ins
Set alerts for when conversions take too long

🚀 Summary

Whether you’re tracking sales speed, lead maturity, or marketing efficiency — knowing how many days pass between a demo and a sign-up helps you act faster and smarter.

With monday.com formulas, you can calculate the number of days.
With Time in Status you can analyze, visualize, and improve it.