How do I add a number of working days to todays date to get a dead

[colourseer]

Hi,
I'm looking for a function, similar to NETWORKDAYS, but that will allow me
to add a number of working days to todays date to generate a deadline,
hopefully I'd like to include Holidays too, just like NETWORKDAYS can, so
based on established timescales, I can generate a date the job will be
completed by.
For instance, If Cell A1 has todays date, and A2 has the number of working
days a job takes to complete, I'd like a function for A3 that will work out
what the date will be when the job is complete.

 

[Mike H]

Try this

=WORKDAY(A1,A2,Holidays)

A1 and a2 are as you describe, strat date and number of days.
Holidays is a named range on the worksheet that contains the dates of any
holidays; public or other, that you want including in the calculation.

Mike

 

[Gord Dibben]

I would say the WORKDAY function would be what you want.

=WORKDAY(startdate,numberofdays)

A1..............Jan1, 2008

B1...............36

C1:C3 contains hoiliday dates.

D1.................=WORKDAY(A1,B1,C1:C3)

If no holidays, just leave out the third argument =WORKDAY(A1,B1)


Gord Dibben MS Excel MVP