Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
Sumif to return a blank if sum range is blank | Excel Worksheet Functions | |||
How do I find the earliest dates in a range of dates? | Excel Worksheet Functions | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions |