Help with Find when dates exceed 6 digits

Looking for support for the Meeting Scheduler found on Youtube July 2018. https://www.youtube.com/watch?v=P0ro...dex=29&t=1960s (Yes I have contacted the creator and waiting to hear back)
When working in Oct-Dec, no meetings are loaded back into the Calendar from 10th of each month. I suspect it has something to do with the increase in digits as Oct/Nov/Dec 10th are the first dates of any month in the year to have 6 digits.
I narrowed down the VBA code issue to the LoadMonth Macro (Load Meetings Into Month) where FoundMonthDates = FindMonthDates.Find(MtgDate, , xlValues, xlWhole) suddenly become "Nothing" from the 10th Oct. As the loop begins, it will correctly identify the Filter Rows and Last Filter Rows, and correctly identifies the MtgDate it is looking for, however, it returns Nothing for the 10th onwards.
Note I made changes to some of the ranges to accommodate changes I made to the calendar to suit my puro=pose. All other months load every meeting listed without issues.
How can this be corrected to allow for the meetings to be loaded correctly?

Please Login or Register  to view this content.

I provided a link to the video which has a link to the workbook. Mine has been added to so much I cannot de-identify it without considerable issue.
I understand how dates are stored in Excel but when a date is displayed as 9/10/21 in the workbook, for example, it is visible and processed as expected. However, whenever a date is displayed with 6 digits ie. 10/10/21 or even 09/10/21 it breaks.

This is broken in the original file so I know I have not altered anything which could have broken it.

I gave the code I narrowed the issue down to and would like to know what limitations the FIND command has in VBA and how this is impacted when a two-digit day of a two-digit month is referenced. No matter how I alter the format of dates throughout the workbook of the VBA code it does not like to process them. The VBA code correctly identifies the date it is searching for, but cannot find it in the range FindMonthDates despite it being there.

Ali, I am still waiting for permission from the original creator to post his work online. I feel strongly about Intellectual Property.
Thank you
While waiting for permission I would simply like to know what the VBA Find function is limiting the dates and what can be done to correct this.
Thank you