Workday Formula

Nitraz Ramchurn

Hi,

I need help about WORKDAY formula. The start date for a task is 10/04/2021 and the duration of the task is 10 working days excluding weekend. I want a formula to calculate the due date which should be a work day only excluding weekend based on the start date and duration. Unfortunately, the WORKDAY formula is not taking into consideration the start date 10/04/2021 and it is giving me the due date of 10/18/2021 instead of 10/15/2021. I don't have dependencies enabled in my Project Settings and the formula I'm using is =WORKDAY([Start Date]@row, Duration@row). Please advise.

Thanks.

Jason P

HI @Nitraz Ramchurn

paste =WORKDAY([Start date]@row, 10) in the cell you want the date to appear, you can then copy the formula to the column so any new row automatically picks it up.

Hope this helps

Nitraz Ramchurn

Hi @Jason P,

Thanks for helping out. Unfortunately this formula won't work for the other tasks as the duration for each task is different and that's why I want a formula that's using the value in the "Duration (Days)" column, see below screenshot.

Laurie Olson

=WORKDAY([Start date]@row, [Duration (Days)@row)