VBA - Generate Date Range Within 2 Supplied Dates (Modified)

Hello All,

I just wanted to understand something about some code that was supplied to me on this forum. The code works perfectly, with the exception of one minor issue. The original thread and solution presented is found here

Please Login or Register  to view this content.

This code works perfectly, except when the value of Sheets("Main").Cells(3, 2).Value at the beginning of the FOR loop is one of the days being looked for (in this case a Sunday or a Wednesday). I would like to know if there is any small modification that I can make to the code that would allow it to not miss the last day if it is one of the days being processed.

I have tried changing around the declaration:

Please Login or Register  to view this content.

but to no avail. Does anyone have any thoughts on this?