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.