| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
