Index Match to determine start and end dates of a project task

[M1donne]

Hi all,

I am familiar (to an extent) on INDEX MATCH but want to incorporate it into telling me the start date and end date of a project, based on and 'x' in every week in which the project 'task' occurs.

I have attached a screenshot of what (in simple terms) I need but I don't think it's quite as simple as an INDEX MATCH

Any help would be greatly appreciated.

Regards

M1donne

 

[Marcelo Branco]

Maybe...

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1
2			Date	01/11/2019	08/11/2019	15/11/2019	22/11/2019	29/11/2019	06/12/2019	13/12/2019	20/12/2019	27/12/2019	03/01/2020	10/01/2020	17/01/2020	24/01/2020
3							x	x	x	x	x
4	Start Date	22/11/2019
5	End Date	20/12/2019
6	Duration	5
Plan3

Cell Formulas
Range	Formula
B4	B4	=INDEX(D2:P2,MATCH("x",D3:P3,0))
B5	B5	=LOOKUP(2,1/(D3:P3="x"),D2:P2)
B6	B6	=COUNTIF(D3:P3,"x")

 

[M1donne]

Perfect, thank you

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.