Determine the Finish Date using NETWORKDAYS

Richard Heath

Hi all,

We have a group of tasks that commence on a given date. [ISSUE DATE]

We would like to automatically populate the adjacent cell with a date, which is +5 business days from the ISSUE DATE. I'm assuming we need to use the NETWORKDAYS formula but I can't determine how to achieve this.

Thanks for your assistance.

Regards,

Richard.

Mark Cronk

Hi @Richard Heath ,

Try:

=Workday([issue date]@row, 5)

Work?

Mark

Mark Cronk

Hi @Richard Heath ,

Try:

=Workday([issue date]@row, 5)

Work?

Mark

Richard Heath

Perfect. Thanks @Mark Cronk

Tanya Brooks

Hi Mark -

I am trying to do a similar calculation.

Need to calculate [Travel End date] plus 30 days

Formula below returning Invalid argument error.  I tried networkday and workday.

=WORKDAY([Travel End date]@row, 30)

Thanks

Mark Cronk

Hi @Tanya Brooks ,

=WORKDAY([Travel End date]@row, 30) should work to add 30 workdays to your Travel End Date.

Confirm that the column the formula is in and the Travel End Date column are both set as Date columns. If the Travel End Date cell is blank you'll get an error so you'll want the final formula to be:

=IFERROR(WORKDAY([Travel End Date]@row,30),"")

Work?

Mark