Error 2042 with application.vlookup for date

I'm trying to lookup up a value in a table. The lookup range is A:E. Column A is a date; Column E is a number. I am not sure why the statement is not returning a value. Column A is formatted as a date. I have the variable myDateEnd declared as a date. When I step through the code I can see a value for myDateEnd and the same value is in the lookup table. I can't figure out why IdxValueEnd is not returning a value (I tried to declare as Long and as Variant but neither method helps). Thanks in advance for any comments.

    IdxValueEnd = Application.VLookup(myDateEnd, wkbData.Worksheets(1).Range("A:E"), 5, True)

Perhaps

IdxValueEnd = Application.VLookup(fix(cdbl(myDateEnd)), wkbData.Worksheets(1).Range("A:E"), 5, True)