FIND Method Not Working??

OK, I probably made some really simple mistake here, but I'm not finding it (no pun intended). Trying to use the Range.Find method to find records of contributions within a certain date range. Here is the code:

Please Login or Register  to view this content.

StartDate, EndDate, and SearchDate are all declared as Date type. StartDate is set to 12/28/15. EndDate is set to 1/3/16. [ContributionsDates] is a range (of 14 contiguous cells within a single column), all formatted as dates, and with the first 6 cells containing dates (that are either 12/31/15 or 1/1/16). Remaining cells in the range are blank.
When I manually step through the macro, each time through the loop (for every value of SearchDate, including 12/31/15 and 1/1/16) FoundDate is set to Nothing so it just steps to DateNotFound.
Why isn't it correctly finding these dates?!?
Running Excel 2007, by the way.

I'm not believing this... whether FIND can find a certain date value depends on the display format of the searched cells?!? That's insane!
But sure enough, it's true. If I format my data table to show the dates as "12/31/15" then FIND doesn't find anything. If I format the cells as "12/31/2015" (without changing anything else) then FIND works.

I wonder what brainiac at Microsoft decided to program it this way (and, of course, not explain this in the reference material)? Makes no sense to me, but THANKS for helping me figure it out!

Actually, it looks like dates aren't the only type of data where FIND is format-sensitive.

After fixing the date problem, the next chunk of code (that used FIND to search for a record number) didn't work either! My record numbers were all formatted to display 5 digits (such as 00017), to distinguish them from other data. When I reformatted that column of cells to General format, then FIND worked.