Custom Formula Help - Workdays

Platform discussions Special workflows & use cases
,
1

I am using two timeline columns to track our “Original Timeline” vs our “Actual Timeline” to track and I want a formula to show how many workdays are between the two.

This is the formula I’m currently using:
WORKDAYS({Original Timeline#End}, {Actual Timeline#End})

This works BUT when the timelines end on the same day (and therefore are on track), it shows “1” and I want it to show “0” (example: IF({Original Timeline#End}={Actual Timeline#End}), 0).

How do I combine the two formulas so that it calculates the workdays unless they are the same, then show 0?

I don’t have access to the AI Formula generator, so need assistance with how this should work.

Thanks!

2

Hi Erin,

Try:

IF({Original Timeline#Start}={Actual Timeline#End}), 
    0,
    WORKDAYS({Original Timeline#End}, {Actual Timeline#Start})
)

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.