I'm pretty sure I'll have to use an array formula for this but here is what I need
4 dates in Columns H, L, M, N I need to find the MAX date from each column's row
Example: =MAX(H5,L5,M5,N5)
But I need to do this for ALL Rows then COUNTIF that Max Date is greater than today's date +30
Example: =COUNTIF(range(frommax),"<="&TODAY()+30)
Here is a visual
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]H[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl64, width: 81, align: right"]10/6/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 73"]
<tbody>[TR]
[TD="class: xl66, width: 73, align: right"]12/3/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][TABLE="width: 73"]
<tbody>[TR]
[TD="class: xl66, width: 73, align: right"]11/5/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl66, width: 81, align: right"]11/22/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 73"]
<tbody>[TR]
[TD="class: xl66, width: 73, align: right"]10/16/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 73"]
<tbody>[TR]
[TD="class: xl66, width: 73, align: right"]11/6/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl66, width: 81, align: right"]11/26/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 73"]
<tbody>[TR]
[TD="class: xl66, width: 73, align: right"]10/28/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 73"]
<tbody>[TR]
[TD="class: xl66, width: 73, align: right"]11/11/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl66, width: 81, align: right"]12/25/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 73"]
<tbody>[TR]
[TD="class: xl66, width: 73, align: right"]10/30/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 73"]
<tbody>[TR]
[TD="class: xl66, width: 73, align: right"]11/2/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]1/16/2016[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl66, width: 81, align: right"]11/5/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 73"]
<tbody>[TR]
[TD="class: xl66, width: 73, align: right"]10/27/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][TABLE="width: 73"]
<tbody>[TR]
[TD="class: xl66, width: 73, align: right"]12/7/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
Today = 10/30/2015
Row 5 = 12/03/2015 (0)
Row 6 = 11/22/2015 (+1)
Row 7 = 11/26/2015 (+1)
Row 8 = 1/16/2016 (0)
Row 9 = 12/7/2015 (0)
Any help please. Thanks
4 dates in Columns H, L, M, N I need to find the MAX date from each column's row
Example: =MAX(H5,L5,M5,N5)
But I need to do this for ALL Rows then COUNTIF that Max Date is greater than today's date +30
Example: =COUNTIF(range(frommax),"<="&TODAY()+30)
Here is a visual
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]H[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl64, width: 81, align: right"]10/6/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 73"]
<tbody>[TR]
[TD="class: xl66, width: 73, align: right"]12/3/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][TABLE="width: 73"]
<tbody>[TR]
[TD="class: xl66, width: 73, align: right"]11/5/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl66, width: 81, align: right"]11/22/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 73"]
<tbody>[TR]
[TD="class: xl66, width: 73, align: right"]10/16/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 73"]
<tbody>[TR]
[TD="class: xl66, width: 73, align: right"]11/6/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl66, width: 81, align: right"]11/26/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 73"]
<tbody>[TR]
[TD="class: xl66, width: 73, align: right"]10/28/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 73"]
<tbody>[TR]
[TD="class: xl66, width: 73, align: right"]11/11/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl66, width: 81, align: right"]12/25/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 73"]
<tbody>[TR]
[TD="class: xl66, width: 73, align: right"]10/30/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 73"]
<tbody>[TR]
[TD="class: xl66, width: 73, align: right"]11/2/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]1/16/2016[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD][TABLE="width: 81"]
<tbody>[TR]
[TD="class: xl66, width: 81, align: right"]11/5/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 73"]
<tbody>[TR]
[TD="class: xl66, width: 73, align: right"]10/27/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][TABLE="width: 73"]
<tbody>[TR]
[TD="class: xl66, width: 73, align: right"]12/7/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
Today = 10/30/2015
Row 5 = 12/03/2015 (0)
Row 6 = 11/22/2015 (+1)
Row 7 = 11/26/2015 (+1)
Row 8 = 1/16/2016 (0)
Row 9 = 12/7/2015 (0)
Any help please. Thanks