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
 
Back
Top