Function DMIN?

[Guest]

Column A = Employee Name
Column B = Date of Activity in Chronological order
Column C = Date of Next Activity
I am trying to use DMIN in column C to find the Date of the next activity
(by searching column B) for the specific employee in column A so I can then
calculate if the date of Next Activity is >= 60 days from the date in Column
B.
I am using the following formula and getting the #value error message
=DMIN(A3:$B$65530,B3:$B$65530,A1:B2)
If I enter the MIN formula as opposed to DMIN, I get a result but it just
finds the min date and doesn't take the employee name variable into account.
=MIN(A3:$B$65530,B3:$B$65530,A2:B2)
Woud the function INDEX be of any help?
Thanks for your help.

 

[Guest]

What is your criteria? That's probably the problem with the DMIN Formula. Is
it mistyped? Does it have extra spaces?
Could you post an example?

tj

 

[Myrna Larson]

Tell us what your criteria range looks like.

What is your criteria? That's probably the problem with the DMIN Formula. Is
it mistyped? Does it have extra spaces?
Could you post an example?

tj

 

[Debra Dalgleish]

Assuming your criteria range is:

A B
1 Emp Name <blank>
2 Fred =C4>=B4

Change your formula to:

=DMIN(A3:$C$65530,3,A1:A2)