Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Min and Max Dates in Range that Contains Zeroes, Dates, and Number
I just can't figure this one out. In Row 7, have a range from Column C to
Column BE that contains cells containing numbers, cells containing dates, and cells containing text. There may be zeroes, the date equivalent of zero, or blank cells in each. Is there a formula that will return the value of the minimum date in the range, disregarding the "zeroes" in date cells and disregarding the cells containing numbers and text? Many thanks in advance for any suggestions! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number of dates falling in a date range | Excel Worksheet Functions | |||
counting the number of dates in a date range | Excel Worksheet Functions | |||
Number of Saturdays within a range of dates | Excel Worksheet Functions | |||
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) |