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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

colourseer - 03 May 2008 16:15 GMT

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.

Reply to this Message

Mike H - 03 May 2008 16:28 GMT

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

> Hi,
> I'm looking for a function, similar to NETWORKDAYS, but that will allow me
[quoted text clipped - 5 lines]
> 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.

Reply to this Message

Gord Dibben - 03 May 2008 17:49 GMT

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

>Hi,
> I'm looking for a function, similar to NETWORKDAYS, but that will allow me
[quoted text clipped - 5 lines]
>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.

Reply to this Message