#VALUE (Wrong data type)

[fayez_MrExcel]

I'm getting a hard time finding what's wrong with my array formula can anybody help me analyze the problem, Im getting "Error in
value"...thanks
{=IF(SUMPRODUCT(('Direct Hire Employee Database'!$BM$2:$BM$65536=$F$18)*(MONTH('Direct Hire Employee Database'!$Y$2:$Y$65536)=$L$4))<ROW()-8,"",INDEX('Direct Hire Employee Database'!$A$2:$BM$65536,SMALL(IF(('Direct Hire Employee Database'!$BM$2:$BM$65536=$L$4)*(MONTH('Direct Hire Employee Database'!$Y$2:$Y$65536)=$L$4),ROW('Direct Hire Employee Database'!$A$2:$Y$65536)-ROW('Direct Hire Employee Database'!$A$2)+1,ROW('Direct Hire Employee Database'!$B$65536)+1),ROW()-8),COLUMN()-2))}

 

[Jonmo1]

1. Formula does not need to be entered as an array..

2. Could be caused if the Dates in Column Y are not actually dates...

try entering this formula anywhere...

=Y2+1

if it returns a date a day after what is in Y2, then they are dates. (although you would want to verify the whole column).

 

[Scott Huish]

try entering this formula anywhere...

=Y2+1

This could coerce the text date to become a date, I would use ISNUMBER to check:

=ISNUMBER(Y2)