calculate business days with excel

Hi there,

I'm currently using "=networkdays" to determine the number of business days between cell A5 and A6.

Say, I wanted to be able to enter a date...let's say Nov-26 and have the next cell automatically tell me the date in the next cell 21 business days into the future

Example:

I enter 29-Oct and it auto populates the next cell with: 26-Nov

Thank you!

NETWORKDAYS gives the number of business days between 2 dates, to add (or subtract) business days from a date use WORKDAY function, i.e.

=WORKDAY(A1,21)

Like NETWORKDAYS this function also accepts a 3rd argument for a holiday range should you want to exclude holidays too