ExcelBanter - need help with networkdays formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - need help with networkdays formula (https://www.excelbanter.com/excel-worksheet-functions/157066-need-help-networkdays-formula.html)

aashishtaneja

need help with networkdays formula

want to setup formula using networkdays through which end date which is 30
workingdays from start date can be calculated.

Mike H

need help with networkdays formula

With a start date in A1 try this:-

=WORKDAY(A1,30,C1:C8)

C1 - C8 are a list of public holidays. This argument is optional soo you
could use.

=WORKDAY(A1,30)

Mike

"aashishtaneja" wrote:

want to setup formula using networkdays through which end date which is 30
workingdays from start date can be calculated.

All times are GMT +1. The time now is 04:33 AM.