I need to subtract workdays and use the formula
WORKDAY({DATE}, -4)
This formula works perfect for adding 4 days (without the minus), but only gives an error if I need to subtract.
This should be such a simple formula but Monday.com doesn’t seem to be able to subtract with workdays attached to the equation. Can anyone help with a SIMPLE formula?
It was working before, but since a few days that’s no longer the case.
I’ve asked the support, but they said to me that’s everything’s work on their side.
It’s still strange that something that worked before no longer works now.
I found a solution that works, but do hope Monday will make a formula update to allow for negative numbers within the workday formula.
You can nest the SUBTRACT_DAYS formula within the WORKDAY formula, but WORKDAY won’t act upon the date unless it’s fed a positive number to apply to it. My solution is to subtract 1 more day than I actually need with SUBTRACT_DAYS and then add that day back with WORKDAY.
Scenario: I have a final due date and need to calculate a milestone deliverable date leading up to the final due date by subtracting working days. I need the formula to return a date. In this case the milestone deliverable is needed 8 days in advance of the final workday due date, which means it could fall on a weekend. I need the date returned to be a workday.
I had hoped this would work, but it does not. In this case the result is exactly the same as if I omitted the WORKDAY formula:
WORKDAY (SUBTRACT_DAYS({final due date},8),0)
But this approach does work:
WORKDAY (SUBTRACT_DAYS({final due date}, 9),1)
I want the date to be 8 workdays prior to the final due date, so I subtract 9 days, and add 1 day back to trigger the workday formula. This formula returns only workdays.