Calculating due dates

Melly

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,

Melissa

David Tutwiler

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)