VBA Loop to check if a date is between two dates

Hello,
I have a VBA Macro that is checking whether or not a date is between two other dates (located on another tab) and if so, then returning the hours from the cell below. It should loop through the two rows of dates until it finds the date it is between and return the corresponding hours.
Below is the code:

Please Login or Register  to view this content.

When I step through the macro line by line it seems to work fine, however, the end result seems to provide only 3 result numbers (which two of the three are incorrect).
Please help. Thanks in advance!

Your loop is set up very confusingly. Why do you loop through C = 1 to ColumnCount, but you don't use C in any of your calculations? Find a way to combine the variable in your loop with PeriodColumn and HoursColumn, then I'd guess you'll find the solution to your problem.

Or, you could post your workbook.