Calculating due dates

Hi there

I am trying to calculate a due date from a "created date" column and a number column,. So want it to calculate the due date given the number in the "target turnaround days column" eg 3, but exclude working days.

Can anyone help please,



  • David Tutwiler
    David Tutwiler Overachievers Alumni

    I think you're looking for the WORKDAY function. It takes in a date and then increments based on a number, but skipping non-work days. So something like this should work:

    =WORKDAY([Created Date]@row, [Target Turnaround Days]@row)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!