Need to create timeline

[kojak43]

I have a task that has multiple steps. The number of steps vary between tasks.

I want to create a formula that can count the number of steps, (easy enough, that I can do that) then after the number of steps are determined, I want to assign two business days for each step. (Here is where I begion to stumble.)

If the numbers of 2 day steps run into a weekend, I want the formula to move the date to the next workday. (I think the function WORKDAY can do this, but when I tried to get this done, Excel sneered at me)

If I have to change a date, I want the worksheet to reflow with the new dates.

Any help out there? It would be greatly appreciated.

K

 

[IML]

It would seem something such as
=WORKDAY(TODAY(),COUNT(A1:A10)*2)
would suffice. Where tasks are listed in A1:A10. subsitute a different date for today() if needed.

Now put down that lolipop and get to work. Who loves ya baby?

good luck

On 2002-02-25 12:05, kojak43 wrote:
I have a task that has multiple steps. The number of steps vary between tasks.

I want to create a formula that can count the number of steps, (easy enough, that I can do that) then after the number of steps are determined, I want to assign two business days for each step. (Here is where I begion to stumble.)

If the numbers of 2 day steps run into a weekend, I want the formula to move the date to the next workday. (I think the function WORKDAY can do this, but when I tried to get this done, Excel sneered at me)

If I have to change a date, I want the worksheet to reflow with the new dates.

Any help out there? It would be greatly appreciated.

K

This message was edited by IML on 2002-02-25 12:18

 

[Tim Francis-Wright]

If you have a bunch of dates that you need populated, then the follwoing might be useful:

If A2 has the first date, then
A3: =WORKDAY(A2,1) will have the second
date for the first task.

Then B2: =WORKDAY(A3,1) and
B3: =WORKDAY(B2,1) will have the two
dates for the next task, etc.

 

[kojak43]

IML:
Thanks for the prompt reply.
No joy. I get the infamous #NAME?
I entered 1-11 in A1:A11, Scribbled in gibberish for each task, then entered your formula at c12.
I also tried the formula at c1 with appropriate changes i.e. Workday(Today(),count(a1)*2)
Both formulas gave me #NAME?
As I really don't know what #NAME? means...
K

 

[IML]

You need to install and select the analysis tool Pak under Tools Add-ins for excel to recognize the workday function. I hope that helps.

On 2002-02-25 12:34, kojak43 wrote:
IML:
Thanks for the prompt reply.
No joy. I get the infamous #NAME?
I entered 1-11 in A1:A11, Scribbled in gibberish for each task, then entered your formula at c12.
I also tried the formula at c1 with appropriate changes i.e. Workday(Today(),count(a1)*2)
Both formulas gave me #NAME?
As I really don't know what #NAME? means...
K

 

[kojak43]

Thank you both. I think I got it to work, thanks to you folks. I am in your debt.
Huge grin!!!