Formula to add or remove workdays

Hi, I’m trying to find a way to calculate a date forward or backward in workdays based on a start date.

So far, I found a lot of ways to calculate for the future in the ohers topics, but none in the past that actually works (except using dependencies which is not simple to understand for basic users)

I will use the General Caster after so I can use that date as a due date and sends notifications.

Thanks in advance for your help!



As I understand it, General Caster uses a slightly modified version of MS Excel formulas.
If you want to create a monday formula separately, that is a completely different question.

For GC it would be something like: WORKDAY({},{item.shift_days})

Welcome to the Community, Dominic!

At this time, we do not have a formula or automation function that will subtract or add workdays from a specific date (although I definitely see why this would be useful).

While we do not have the internal capabilities to achieve this at this time, something you can always try instead would be to use one of our 3rd party platform integrations to build your own automation:

Otherwise, if you are comfortable coding or have access to any developers, you can build your own automation using our API:

If you need help building custom integrations, we also have an option for paid assistance through our network of certified partners. If this interests you, simply fill out this form and someone will be in touch shortly!

Hope this helps :slight_smile:


Hello, I found out how to do it

  • One column with the days foward
  • One column with the days backward
  • Use a formula depending on if we have to go forward or backward

IF({#Days backward}>0;RIGHT(LEFT(CONCATENATE(WORKDAY(“2021-08-25”, (5-{#Days backward}+1))), 15), 11);RIGHT(LEFT(CONCATENATE(WORKDAY(“2021-09-01”, ({#Days forward}+1))), 15), 11))

In this example
*Every date is based on 2021-09-01.
*5 = Maximum of days backward in my case
Backing 5 wordays gives me the 2021-08-25
So I check if I there is a number in days backward and use the right formula


That’s great to hear that you found a solution, @dperrier!

We will go ahead and close this out now but let us know if you have any more questions :slight_smile:

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