Hi,
Kindly help me on the following

I have two rows: 1st row with dates (May) and 2nd row is blank.

I want to count the blanks automatically comparing with today's date.

ex:
row1: 1-May 2-May 3-May 4-May
row2:

if today's date is 2-May, then I want the answer as 3.

please help me.