Create Manual Date

[reza]

Hi All,

need formula to create start and end date from many activity like MS Project.
example;
Start End
Task 1
Task 1.1 August 12, 2009 August 20, 2009
Task 1.2 August 10, 2009 August 21, 2009
Task 1.3 August 05, 2009 August 30, 2009

so in task 1 by automatic will fill with start August 05, 2009 and Finish
August 30, 2009, MS Project...
can excel do that?

thanks

reza

 

[Jacob Skaria]

Col A Col B Col C
Start End
Task 1 =for1 =for2
Task 1.1 12-Aug-09 20-Aug-09
Task 1.2 10-Aug-09 21-Aug-09
Task 1.3 5-Aug-09 30-Aug-09

(Format the formula cells to excel date format)
Please note that this is an array formula. Within the cell in edit mode (F2)
paste this formula and press Ctrl+Shift+Enter to apply this formula. If
successful in 'Formula Bar' you can notice the curly braces at both ends like
"{=<formula>}"

Formula 1 in cell B2 would be
=MIN(IF(LEFT($A$3:$A$10,LEN(A2))=A2,$B$3:$B$10))

Formula 2 in cell C2 would be
=MAX(IF(LEFT($A$3:$A$10,LEN(A2))=A2,$C$3:$C$10))



If this post helps click Yes

 

[reza]

Jacob....

i do what you said...but the result is 0-jan-00.
can you more detail step by step to do this..

many thanks

 

[Jacob Skaria]

--Try with just the below data 5 rows.
--The dates should be in excel/date format.

Col A Col B Col C
Start End
Task 1 =for1 =for2
Task 1.1 12-Aug-09 20-Aug-09
Task 1.2 10-Aug-09 21-Aug-09
Task 1.3 5-Aug-09 30-Aug-09

If this post helps click Yes

 

[reza]

great...awesome....
thanks jacob....


reza

--Try with just the below data 5 rows.
--The dates should be in excel/date format.

Col A Col B Col C
Start End
Task 1 =for1 =for2
Task 1.1 12-Aug-09 20-Aug-09
Task 1.2 10-Aug-09 21-Aug-09
Task 1.3 5-Aug-09 30-Aug-09

If this post helps click Yes