Need formula to return Earliest and Last Date

[shapenote]

Ok ... so I have a spreadsheet that is tracking a renovation project. At the top, running horizontally, I have the dates of when different aspects of the project starts.

Below that I have several rows of itemized projects and conditional format the cells, so that when I put an "x" under any given date for that line item, it will shade the cell red.

Now, I want to add two columns and formulas so that - one that tells me the start date (i.e. when the shading starts) and the other return the date of when that line item is estimated to end (i.e. the date of the last shaded cell). I want this formula driven so that if I need to move the start/end dates (i.e. my "x"), the dates change as well.

What would be a good formula for that?

 

[Peter_SSs]

.. the other return the date of when that line item is estimated to end (i.e. the date of the last shaded cell).

How is that last shaded cell determined in your conditional formatting? Does that last cell also get an "x" in it?

 

[shapenote]

Yes ... even the last cell gets an x.

 

[Peter_SSs]

Try this then

Excel Workbook
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Start	End		1/10/2018	8/10/2018	15/10/2018	22/10/2018	29/10/2018	5/11/2018	12/11/2018	19/11/2018	26/11/2018	3/12/2018	10/12/2018	17/12/2018
2	8/10/2018	29/10/2018			x			x
3
4	15/10/2018	3/12/2018				x							x
5	5/11/2018	5/11/2018							x
Project

 

[shapenote]

That worked!!! THank you much!

 

[Peter_SSs]

That worked!!! THank you much!

You're welcome. Thanks for letting us know.