Hello Folks,
The “Duration” column automatically includes weekend days when totaling days. I’m trying to exclude weekend days in the total.
Do I need a formula to count the business days from the “Timeline” column? Or is there a way to edit the formula of the “Duration” column?
Either way, how would I set up the formula? I have a screenshot of my workspace below.
By the way, going to Administration and then clicking Hide Weekends does not achieve this goal.
Hi @makolytics,
If you don’t want it to count week-ends, you’d have to hide week-ends under Administration > General > Account.
Or add a formula column and use this formula:
NETWORKDAYS({Timeline#Start},{Timeline#End})
For more details, see: The monday Hidden Functions – The Monday Man