Max unless blank

[Jacilyn]

I would like to calculate the Maximum date resolved from a column of resolved dates, unless there are blanks in the resolved dates column. If there are blank cells in the column, I would like the result to come back as blank.

The intent is to highlight whether there are outstanding service requests, and if none - when he last one was resolved.

I was thinking it may be a combination of a MAX and IF function, but advice would be appreciated.

Jacilyn

 

[joeu2004]

=if(count(d1:d100)=0, "", max(d1:d100))

 

[Peter_SSs]

Welcome to the MrExcel board!

The intent is to highlight whether there are outstanding service requests, and if none - when he last one was resolved.

My interpretation of that is

=IF(COUNTBLANK(D1:D100), "", MAX(D1:D100))