Start date calculations...

[Dave Ramage]

Hello,

I've been puzzling on this one for a whle now and can't
seem to come up with a solution that works for all cases.
Would be grateful if anyone can suggest something...

On a Gant Chart/Timing Plan I have column F as Start Date
and column G as Duration. I need a formula that calculates
the next start date based on the start date and duration
of the previous row/task. The problem is, I only want to
count week days E.g

F G
1 | Start Date Duration (working days)
2 | 26-Jan-04 15
3 | ? 32
4 | ? 3

F3 should be 16-Feb-04 and F4 should be 30-March-04. If it
helps, row 2 from N2 onwards contains the date headings
for the task bar section, starting on 26-Jan-04.

Unfortunately the NETWORKDAYS function does not take an
array argument, otherwise it would be fairly easy...

Cheers,
Dave

 

[Frank Kabel]

Hi Dave
for F3 try the formula
=WORKDAY(F2,G2)
copy down
if you also want to include holidays you may use the third parameter of
WORKDAY to reference a list of free days

Frank

 

[Dave Ramage]

Frank,

I can't believe I spent so long on this and there was
built in function all the time!

Thanks for this- I wouldn't have found it myself.

Cheers,
Dave