help with Blank Dates in a Range
 

Hi...I need your help.
I have a range of cells formatted as date cells that I want to return the
most recent date from the range. If all the cells in the range are blank I
want to return a blank cell or a text entry like "None". I found the "MAX"
function to get the most recent date but I can't find a function to return
None if all the cells in the range are empty.

Any Ideas?

Thanks,

--
Jerry

help with Blank Dates in a Range
 

=IF(COUNT(A:A),MAX(A:A),"")

Format cell as Date


"Jerry Rogers" wrote:

Hi...I need your help.
I have a range of cells formatted as date cells that I want to return the
most recent date from the range. If all the cells in the range are blank I
want to return a blank cell or a text entry like "None". I found the "MAX"
function to get the most recent date but I can't find a function to return
None if all the cells in the range are empty.

Any Ideas?

Thanks,

--
Jerry