need help with networkdays formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

want to setup formula using networkdays through which end date which is 30
workingdays from start date can be calculated.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

NETWORKDAYS HELP 0
networkdays alternative 2
NETWORKDAYS 1
NETWORKDAYS 2
CALCULATE BETWEEN TWO DATES EXCLUDING WEEKENDS 3
NETWORKDAYS ADD-IN PROBLEMS 1
NETWORKDAYS 1
Problem with NetworkDays ... Inconsistent results 0

Back
Top