I would appreciate any and all help on the following:

I have three columns:
Column B has dates from 1/1 to 12/31.
Column C has weekdays from Column B.
Column D has both numbers and blank cells from formulas referencing another sheet.

Column D is sectioned off weekly, meaning that every Sunday is a blank cell.
Column D has zeroes to the last date of the year.

Here’s an example:

B C D
7/10 Fri 5
7/11 Sat 10
7/12 Sun
7/13 Mon 5
7/14 Tue 6
7/15 Wed 8
7/16 Thu 6
7/17 Fri 0
7/18 Sat 10
7/19 Sun
7/20 Mon 5

I would like to find the first number greater than zero immediately after the last zero in Column D not counting the last cell in the column, and return the corresponding date from Column B.

I am not looking for the last zero, which would correspond to 12/31.

So for the above example, I would like to have 7/18 as the answer.

Thanks all.