Only include Business Days in Due Date Formula

Platform discussions
1

I’m currently using a formula to automatically generate a due date for a task based on when the user starts working on that task and the number of estimated days it’s going to take.

For clarification: I have a 'Date Started" column that generates the current date based on when the item is switched to working on it; an “Estimated Days” column with the number of estimated days to complete the task, and then a “Due Date” column.

In my due date column, I currently have the below formula:

FORMAT_DATE(ADD_DAYS({Date Started},{Estimated Days}),“MMM DD”)

Is there a way I can set this up to only account for business days?
For example, if I start a task on Thursday and it takes an estimated 3 days, I’d like the due date not to read Sunday, but to read Monday.

Thanks in advance.

1 Like
2

A similar issue was answered by Monday staff last year. It’s not exactly the same but it may provide a direction for a solution.

2 Likes
3

Hi Josh, I use this formula with the number “21” being variable (the amount of days to calculate)

RIGHT(LEFT(CONCATENATE(WORKDAY({Date Processed},21)),15), 11)

Although, it seems Monday has updated in the last few days to show a ‘Business Days’ option in the automations!

4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.