# Determine the Finish Date using NETWORKDAYS

✭✭✭✭✭✭

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.

Regards,

Richard.

• ✭✭✭✭✭✭

Try:

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

Work?

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• ✭✭✭✭✭✭

Try:

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

Work?

Mark

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

• ✭✭✭✭✭✭

Perfect. Thanks @Mark Cronk

• 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

• ✭✭✭✭✭✭

=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

I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!