View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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.