Dates test

R

Ron2

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
 
F

Frank Kabel

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