I don't know why I'm getting zeros here. The reference sheet for Range 1 is a date column and Range 2 matches what is in the drop down menu. I also suspect that there's a more efficient formula to use - your feedback is welcome!
Try removing the ISDATE function and just reference Date1 directly.
That's why you're my favorite.
Haha. Happy to help! 👍️