Schedule start/end date

[Guest]

I am trying to create a formula that puts the start and end date into a cell based on entering a number in the date on which the task starts.
dates in days >>>>>>>>>>>>>>>
1 task start end 1/9 1/10 1/11 1/12
2 job1 1/9/2004 1/11/2004 1 2
3 job2 1/12/2004 1/12/2004 1
4 job3

^ put the start date (from row 1) from the task row cell that contains a 1
^ put the end date (from row 1) from the task row cell that contains a 2. if no 2 exists, use
the start date

can't figure out the formula to enter the start and end date. Thanks.

 

[Arvi Laanemets]

Hi

When dates table is in range p.e. E1:H4

B2=IF(ISERROR(MATCH(1,($E$2:$H$4,ROW(A1),,1),0)),"",INDEX($E$1:$H$1,1,MATCH(
1,INDEX($E$2:$H$4,ROW(A1),,1),0)))
C2=IF(ISERROR(MATCH(2,INDEX($E$2:$H$4,ROW(A1),,1),0)),B2,INDEX($E$1:$H$1,1,M
ATCH(2,INDEX($E$2:$H$4,ROW(A1),,1),0)))


--
(When sending e-mail, use address (e-mail address removed))
Arvi Laanemets

I am trying to create a formula that puts the start and end date into a

cell based on entering a number in the date on which the task starts.

dates in days
1 task start end 1/9 1/10 1/11 1/12
2 job1 1/9/2004 1/11/2004 1 2
3 job2 1/12/2004 1/12/2004 1
4 job3

^ put the start date (from row 1) from the task row cell that contains a 1
^ put the end date (from row 1) from

the task row cell that contains a 2. if no 2 exists, use