On Sat, 12 Nov 2011 13:50:25 -0500, Ron Rosenfeld wrote:

On Sat, 12 Nov 2011 11:22:25 -0500, Stan Brown wrote:

The date submitted is in (let's say) D31. I need a formula that
selects the latest date in (A11:A15,A21:A25) but disregarding any
rows where column B or C has a 1.

You don't give any indication of the significance of the date in
D31; nor can I guess at that from what you have written.

Sorry, I didn't realize it mattered. But in case it wasn't obvious
from "time sheet", the dates are M-F within two work weeks.

The latest date in (a11:a15,a21:a25) is given by the formula:
This formula must be **array-entered**:

=MAX(MAX(A11:A15*(B11:B15<1)*(C11:C15<1)),MAX(A2 1:A25*(B21:B25<1)*(C21:C25<1)))

Great; thanks!

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...