Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create vertical line to indicate date on chart with series of date | Charts and Charting in Excel | |||
date format changes when I save to CSV via a macro, but not manual | Excel Discussion (Misc queries) | |||
Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
Auto Date with Manual Entry Protection | Excel Worksheet Functions | |||
RECORDED MACRO PASTE'S DATE DIFFERENTLY TO MANUAL PASTE | Excel Worksheet Functions |