查找100K的日期位置以及行电子表格效率

Had some good help from some great folks yesterday. I extrapolated on it and wanted to ask if anyone knew of more efficient ways to do this. Finding the start date locations are very efficient as it's nearly 3 lines of code, but the finding the end dates is a bit harder because it finds the first instance of the date and then iterates over a loop until it reaches the end, which is inefficient for obvious reasons. These are two separate functions (one to find the start rows of the date and one to find the last row of the end date. Anyone have any ideas? Code belowHad some good help from some great folks yester