Subtracting Days from a Due Date

[gabrielledagosta (Gabrielle)]

Hello,
I need a formula that subtracts # of days (using a NUMBER) column from a Date (DATE column) to get a final DATE column. And I need it to use workdays not calendar days.

[dmccarthy22710 (Desiree McCarthy | monday.com Ambassador)]

This doesn’t cover work days, only calendar days. Using a ‘negative’ will work with the automation.

[gabrielledagosta (Gabrielle)]

Thanks, I have a formula for this but I need it to factor workdays.

[dmccarthy22710 (Desiree McCarthy | monday.com Ambassador)]

Do you have Enterprise? You can do this with workflows

[EmilySlade]

Please can you tell me more about this! I have the same issue and have Enterprise - please can you share a step by step? Thank you. Ideally please can we have SUBRACT WORKDAY as a feature?

[dmccarthy22710 (Desiree McCarthy | monday.com Ambassador)]

@gabrielledagosta

Hello,
I need a formula that subtracts # of days (using a NUMBER) column from a Date (DATE column) to get a final DATE column. And I need it to use workdays not calendar days.

I’m trying my hand at a youtube video to walk through this for you - https://youtu.be/CQZxulVbUGI

[reinier (Reinier ― 📅 Calendar Plus 🍅 Automato)]

Hi Gabrielle,

I assume you’ve already solved this by now, but in case you haven’t, we offer exactly this automation as part of our marketplace calendar app. For example, this example sets a reminder date 1 day in the past, skipping any weekend days. Tuesday is moved to Monday, Monday to Friday!

–