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
---------------
Jacob Skaria


"reza" wrote:

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