Alan,
Thank you for your help, but I'm trying to stay away from macros.

TMS,
Thank you also. The first helper column is wonderful. Although sadly, 7/17 is the 5th occurrence of a zero.

Because I have a formula in each cell in Column D (your Column C), excluding Sundays, I have a bunch of zeroes through the rest of the column. This makes your INDEX/MATCH formula unworkable.

If it would help to insert my Excel sheet let me know, and I'll do that.

Thanks again.