Formula to calculate Due Date as a Workday

[Francoloco23]

Good day Airtable Team,

I would like to ask for your assistance in a formula to compute for the due date based on the following scenarios:

1. Due Date if Rush Tag is Yes: Variables to be used would be "Extracted for Ticketing" and "Rush TAT".

2. Due Date if Rush Tag is No: Variables to be used would be "Extracted for Ticketing" and "Rush TAT".

Thank you

 

 

[TheTimeSavingCo]

Assuming "WD" stands for a day or something, try something like:

DATEADD(
  DATETIME_PARSE(
    Date,
    "MM/DD/YYYY"
  ),
  VALUE(
      SUBSTITUTE(
        SWITCH(
          Rush,
          "Yes",
          {Rush Time},
          {Standard Time}
        ),
      "WD",
      ""
    )
  ),
  'days'
)

 Link to base

[Francoloco23]

Hi @TheTimeSavingCo,

When I applied the formula, the date and time were not the values that I wanted. I believe the column "Extracted for Ticketing" has a time that is why an error would occur when the formula would be applied.

Thanks

[TheTimeSavingCo]

Hm, that shouldn't affect anything:

Could you provide a screenshot of the error you're seeing when you try to use the formula? 

[Francoloco23]

Hi @TheTimeSavingCo ,

Here

 

 

[TheTimeSavingCo]

At a glance I can't see anything wrong there.  Could you send me an invite to your table so I could troubleshoot it from there?

[Francoloco23]

Hi @TheTimeSavingCo,

May I know your email address for the invite?

Thanks

[Francoloco23]

Hi @TheTimeSavingCo ,

I already sent an invite.

Thanks