That did help. And I did figure out what my issue was.
The MID() function that I was using to extract the date from the text string was storing it as TEXT even though I formatted the cells as DATE. I ended up finding the DATEVALUE() function which converts a date from text to the serial that Excel recognizes as a date. Once I did that, it started working!
Thanks for the assist!