Gerry,
Just to let you know, I am haviing real problems testing this as I don't have the calendar control on this machine. When I downloaded it, it wouldn't register as the OS is 64 bit (you might want to think about that). I will need to try it on another 32 bit machine later.
For my info, you have Search_****_Finance sheets that has code that moves completed from Database to Finance Passed, and Search_***_Complete that has code that moves completed from Finance Passed to Completed. Is this the actual flow?