Using workday and networkdays to return project start date

[David Ferguson]

Hello,

I'm trying to get my head round the workday and network day functions
and can't quite figure it out... I need to obtain the date on which a
task must start given that it must be finished by a known date and
given the number of WORKING days it is planned to take (Mon - Fri, no
holidays).

e.g.
Need Date: 15-August-2003
Project Days: 7
Required Start Date: 06-August-2003

(i.e project starts 6th August and is finished by the end of the day
on the 14th)

How can I do this?

TIA,

Dave Ferguson

 

[Andy B]

David

Use WORKDAY function but enter the project days as minus.

Andy

 

[Andy B]

. . and enter the end date in the function !!

David

Use WORKDAY function but enter the project days as minus.

Andy

 

[Norman Harker]

Hi David!

You should really try Help for the functions as the "first port of
call." It can be annoying at times and some finer detail is omitted.
But in the case of the WORKDAY function, here's what help says about
the days argument:

"Days is the number of nonweekend and nonholiday days before or
after start_date. A positive value for days yields a future date; a
negative value yields a past date."

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Thursday 31st July: Bermuda (Cup Match Day),
Congo (Upswing of the Revolution), Mexico (Day of Mourning), Peru (San
Ignacio). Observances: Lunasa / Lammas (Pagan N. Hemisphere), Oimelc /
Brigid (Pagan S. Hemisphere)
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.