I am trying to find the earliest date that falls within date range that

matches an employees name. . M$2 is today's date and N$2 contains a
date 3 years earlier. "names" is the range of employees and
"accident_dates" contains the dates

When I use the array formula I created below, I get a blank cell even
though I know a corresponding value exists.


{=MIN(IF(Names=A3,Accident_dates))*((Accident_date sN$2)*(Accident_dates<M$*2))}



Thanks for any help you can provide


Steve

Try this (array entered):

=MIN(IF((Names=A3)*(Accident_datesN$2)*(Accident_ dates<N$2),Accident_dates))

Are you sure you don't want to use: = and <= ?

Biff

"Steve" wrote in message
oups.com...
I am trying to find the earliest date that falls within date range that

matches an employees name. . M$2 is today's date and N$2 contains a
date 3 years earlier. "names" is the range of employees and
"accident_dates" contains the dates

When I use the array formula I created below, I get a blank cell even
though I know a corresponding value exists.


{=MIN(IF(Names=A3,Accident_dates))*((Accident_date sN$2)*(Accident_dates<M$*2))}



Thanks for any help you can provide


Steve

Thanks Biff for the formula and the suggestion to <= and =... works
well !

Steve




Biff wrote:
Try this (array entered):

=MIN(IF((Names=A3)*(Accident_datesN$2)*(Accident_ dates<N$2),Accident_dates))

Are you sure you don't want to use: = and <= ?

Biff

"Steve" wrote in message
oups.com...
I am trying to find the earliest date that falls within date range that

matches an employees name. . M$2 is today's date and N$2 contains a
date 3 years earlier. "names" is the range of employees and
"accident_dates" contains the dates

When I use the array formula I created below, I get a blank cell even
though I know a corresponding value exists.


{=MIN(IF(Names=A3,Accident_dates))*((Accident_date sN$2)*(Accident_dates<M$*2))}



Thanks for any help you can provide


Steve

You're welcome. Thanks for the feedback!

Biff

"Steve" wrote in message
oups.com...
Thanks Biff for the formula and the suggestion to <= and =... works
well !

Steve




Biff wrote:
Try this (array entered):

=MIN(IF((Names=A3)*(Accident_datesN$2)*(Accident_ dates<N$2),Accident_dates))

Are you sure you don't want to use: = and <= ?

Biff

"Steve" wrote in message
oups.com...
I am trying to find the earliest date that falls within date range that

matches an employees name. . M$2 is today's date and N$2 contains a
date 3 years earlier. "names" is the range of employees and
"accident_dates" contains the dates

When I use the array formula I created below, I get a blank cell even
though I know a corresponding value exists.


{=MIN(IF(Names=A3,Accident_dates))*((Accident_date sN$2)*(Accident_dates<M$*2))}



Thanks for any help you can provide


Steve

=MIN(IF((names=A3)*(adn2)*(ad<m2),ad))

--
Don Guillett
SalesAid Software

"Steve" wrote in message
oups.com...
I am trying to find the earliest date that falls within date range that

matches an employees name. . M$2 is today's date and N$2 contains a
date 3 years earlier. "names" is the range of employees and
"accident_dates" contains the dates

When I use the array formula I created below, I get a blank cell even
though I know a corresponding value exists.


{=MIN(IF(Names=A3,Accident_dates))*((Accident_date sN$2)*(Accident_dates<M$*2))}



Thanks for any help you can provide


Steve