calculating an ending date based on networkdays

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

Guest

I have a start date and I know how many work days it should take to complete the task. I am trying to develop a formula that will add weekends to my estimated work days and calculate a projected end date. I know how to calculate networkdays when you have an end date, but just how in blazes do you add networkdays when you don't know how many there are in order to determine the end date????
 
Hi
try WORKDAY:
=WORKDAY(A1,10)
this will add 10 working days to A1. You can also include a 3rd
parameter referencing holidays

Frank
 

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 2
Using Networkdays with negative numbers 4
networkdays alternative 2
Multi NetWorkDays Calculation 3
CALCULATE BETWEEN TWO DATES EXCLUDING WEEKENDS 3
Calculating number of workdays between 2 dates 14
Skipping weekends during a count 1

Back
Top