NETWORKDAYS and producing future dates

[mikaselm]

I want to make a little chart for easy reference that tells me due dates for projects, based on estimated completion times.

I'm already using NETWORKDAYS to find the amount of working days between today and a due date, but I want to flip the formula around, and I'm having trouble getting the syntax right.

For example, column A reads:

0
1
2
3
5
7
10
15
20

Estimated completion times for various projects
So I want column B to read the date that this would render. A1, value 0, would always produce today's date for B1. B2 would always read one business day into the future, B3 would read as 2 business days into the future, B4 as 3 business days into the future. Does that make sense, and B5 as 5 bd into future.

Thank you all so much!

[daffodil11]

B1 = TODAY()+A1

and copy down

[xenixman]

I think you are looking for the =WORKDAY() function.

=WORKDAY(StartDate,Days,Holidays)

Use this function to calculate a past or future date based on a starting date and a specified number of days.
The function excludes weekends and holidays if indicated.