earliest date in a range by employee

S

Steve

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_dates>N$2)*(Accident_dates<M$2))}

Thanks for any help you can provide

Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

finding earliest date within a range by employee 4
Earliest time in a range 3
Moving Amounts to Another Workbook Based on 2 Conditions - Date/Employee 3
Assigning a value to one cell based on the date in another... And then doing it again 0
a task which starts when the earliest of several other tasks start 0
Select Next Earliest Date if Date Field Null 0
Finding the earliest date from a range of cells 2
copy a range 0

Top