G
Guest
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,
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,