Help with Difference between two Dates

Platform discussions
,
1

Hi,

I am trying to calculate the difference (in workdays) between two Dates.

imagen
imagen454×224 6.35 KB

I need the difference between “F. Ent V0” & “F. Ent SOL”.
There is not a start date and a finish date, both are independent dates. I mean, the result can be “2 days” or “-2 days”.

I tried workdays formula and netdays formula.
But I don’t understan the results you can see. When both are the same date, the result is 1 day. When the difference is 1 day between both dates the result is sometimes 2 days and sometimes 0 days.

imagen
imagen447×218 6.59 KB

How can I calculate the difference between two dates, but without a start date and a finish date?
It is possible results like “3 days” and “-3 days”?

Thank you!

2

Hi @daniel.cubicup,

Try:

IF({F. Ent SOL}>{F. Ent VO},
     CONCATENATE(WORKDAYS({F. Ent SOL}, {F. Ent VO})-1," days"),
     CONCATENATE(1-WORKDAYS({F. Ent VO}, {F. Ent SOL}), " days")
)

 

Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.

  • Create formulas without using the Formula column (and avoid its limitations)
  • Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
  • In one formula, update multiple columns from multiple items.

Check our blog for real use cases.

3

Hi Gilles,

Thank you for your help. It works!

The problem is that Monday does not recognize the results as a numeric data so I can not calculate the average of the columns.
Do you know how can I fix this?

imagen
imagen380×266 8.42 KB

Again, thank you very much for your time.

4

Hi Daniel,

Then use:

IF({F. Ent SOL}>{F. Ent VO},
     WORKDAYS({F. Ent SOL}, {F. Ent VO})-1,
     1-WORKDAYS({F. Ent VO}, {F. Ent SOL})
)

And, in the summary, change the Unit to días.

 

What if we could break free of the Formula column? and write formulas that update any type of columns? What if a formula could update multiple columns at once? This is possible with the Advanced Formula Booster app.

5

Wow, it is perfect now!

Thank you very much for your help Gilles!!