Dates test
 

Am trying to come up with a single cell formula (as
opposed to a macro) that finds the maximum date from a
range of 50 date cells (A1:A50) that falls between two
dates that are listed in 2 separate date cells (B1 and
C1).

Thanks in advance.

Ron

Dates test
 

Hi
try the following array formula (entered with CTRL+SHIFT+ENTER):
=MAX(IF((A1:A50=B1)*(A1:A50<=C1),A1:A50))

--
Regards
Frank Kabel
Frankfurt, Germany


Ron2 wrote:
Am trying to come up with a single cell formula (as
opposed to a macro) that finds the maximum date from a
range of 50 date cells (A1:A50) that falls between two
dates that are listed in 2 separate date cells (B1 and
C1).

Thanks in advance.

Ron