calculating an ending date based on networkdays

M

mddaley

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????
 
F

Frank Kabel

Hi
try WORKDAY:
=WORKDAY(A1,10)
this will add 10 working days to A1. You can also include a 3rd
parameter referencing holidays

Frank
 
Top