countblank

[kumar_viswa2003]

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.

[Domenic]

Try...

=COUNTBLANK(A2:INDEX(A2:D2,MATCH(TODAY(),A1:D1,0)))+1

OR

=COUNTBLANK(A2:INDEX(A2:D2,MATCH(A5,A1:D1,0)))+1

...where A5 contains the date of interest.

Hope this helps!

[kumar_viswa2003]

Its working fine......... thx.