Formula to calculate Due Date | Airtable Community

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

Page 1 / 1

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

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

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

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

Hm, that shouldn't affect anything:

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

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

Hi @TheTimeSavingCo ,

Here