Dependency Formulas for Task Worksheets

[dheardzimin]

Hey All

Hope you can help me. I am trying to build a worksheet that is sort of a Project Plan. Why am I not using Project - simple - not everyone in my company has Project, and exporting in Project 2007 is just nasty!

The issue can be described with a simple example:

Imagine the sheet with the following columns

Task Ref - Task Description - Dependency - Start Time - Duration - End Time

Duration is in Minutes, End time is calculated as a formula adding the Duration to the start time using the TIME function.

Dependency contains the Task Ref of the task that must complete before the task in question can start. I would like to have a formula for start time, that pulls in the value for end time of the task identified in the Task Ref column - can anyone help?

Thanks in advance!

 

[anupmenon85]

Hi, I am using the formula with dates in the "Task End Date" column, and the problem is it is picking the min date not the max date. Here is what I'm using.
=IF($G13="","",MAX(IF(ISNUMBER(FIND(","&$A$12:$A$50&",",","&$G13&",")),$I$12:$I$50)))

I do enter with ctrl+shift+enter to get curly brackets.

 

[anupmenon85]

Hi,

When I use this formula with dates instead of numbers, I am getting the min date and not the max date. Do I need to change something to allow for DATES?