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
<tbody>
</tbody>
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
H | L | M | N | ||||
5 |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
6 |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
7 |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
8 |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | 1/16/2016 | |||
9 |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
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