How to calculate days between two dates

I have a demo date and a sign up date. I’m trying to do two things:
1 - calculate the time between the two dates
2 - somehow represent this visually in some sort of chart, battery or I don’t know so that we can see if we are getting people to sign up faster

Thanks in advance for any help/direction!

Hi Laurie,

Fortunately, that should be super simple in monday.com. This will calculate the days between two dates:

DAYS(
    {Sign Up Date},
    {Demo Date}
)

Create a formula column using this formula and update the names in the curly braces to match your column names.

You can then use that formula to populate a chart. It sounds like a line chart would make sense in your case.

Set the X axis to be the sign up date and group by week or month, depending on what you want to track.

Set the Y axis to be the result of the formula column you created.

There are more ways to configure this if you need to do something particular like round the days up or down or calculate based on exact time or working days for instance. Hopefully this gets you started though.

Let me know if you need more help and feel free to reach out if you want some assistance getting this all configured.

Hello,

Would this formula work if one of the columns you are using is a date column but the other is a timeline column?

I have a “start date” for projects (which is a date column, aka uses a single date) and then an “installation date” (which uses a timeline column as the installation can span more than 1 day).

I am currently calculating how many weeks it has been from “start date” to “today”, but I want this formula to stop calculating once I enter an installation date.

the installation date can either be just 1 day or can span multiple days. Is it possible to get the formula to pick out the ending date from my timeline column and use that to end the formula from continuing to calculate?

Hi Michelle,

Yes, use {Timeline#End} to get the end date of your timeline.


Want to get rid of the formula column and write formulas that support multiple lines, variables and can update various columns at once)? Take a look at the Advanced Formula Booster at https://mdboosters.com

1 Like

This is my current formula

ROUNDDOWN(SUM(DAYS(TODAY(), {Go Ahead}),1)/7,0)&IF(ROUNDDOWN(SUM(DAYS(TODAY(), {Go Ahead}),1)/7,0)=1," week “,” weeks ")

I replaced “TODAY” with my timeline column name but it did not work. Any suggestions?
GO AHEAD is my starting date column.

  1. INSTALL DATE is my timeline column.

Hi @lrpaquette :wave:
Welcome to the community!

For calculating the time between the two dates try Time in Status app which helps to track time the Item has spent in each workflow status easily. So you can monitor how fast the Item moves between statuses.
You’ll get user-friendly data on the board in a few seconds.

Also you will be able to track how much time your issue spends in each status and much more by generating:

:chart_with_upwards_trend: And use charts to visualize your reports a sample of a certain number according to time range/item range, or a single item:

  • Pie Charts
  • Bar Charts
  • Area Charts

The app is also available in the format of board integration.

Start the 14-days free trial to try it out for yourself and share your experience with us.

Hope you find this app helpful,
Valeriia

1 Like