Create Manual Date
 

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

Create Manual Date
 

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

Create Manual Date
 

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" wrote
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

Create Manual Date
 

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


"reza" wrote:

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" wrote
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

Create Manual Date
 

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


reza

"Jacob Skaria" wrote:

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


"reza" wrote:

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" wrote
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