Excluding weekends in formula that counts days since a status changed

Platform discussions Special workflows & use cases
1

Hey team, new here but I am using this formula currently ROUND(DAYS({Loan fired to LC},TODAY()),0) but it is counting calendar days, and I just want it to count business days. I went into the general setting and excluded weekends there but that didn’t do the trick. How do I modify this formula to only count business days

2

Hi Scott,

Simply replace DAYS by WORKDAYS.

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!
Use data from the previous item, next item, sub-items, parent item, items in the same group, items in the same board.
In one formula, update multiple columns from multiple items.
Check our blog for real use cases.