Is this what you mean?

=IF(NOT(COUNTA(A1:G1)),"Please pay",
IF(COUNT(Sheet1!A1:G1),IF(TODAY()=MAX(Sheet1!A1:G 1),"Expired",
INDEX(Sheet1!A1:G1,,MIN(IF(Sheet1!A1:G1TODAY(),CO LUMN(Sheet1!A1:G1)))-COLUMN(Sheet1!A1:G1)+1)-TODAY()),""))

--
__________________________________
HTH

Bob

"puiuluipui" wrote in message
...
Hi, i have this formula that show me how many days i have until next pay:
{=IF(COUNT(sheet1!A1:G1),IF(TODAY()=MAX(sheet1!A1 :G1),"Expired",INDEX(sheet1!A1:G1,,MIN(IF(sheet1!A 1:G1TODAY(),COLUMN(sheet1!A1:G1)))-COLUMN(sheet1!A1:G1)+1)-TODAY()),"")}

In this range (A1:G1)i have dates. In every month i have to pay something.
i need to make a table in sheet2!A1:G1 in which i will write OK when the
rate is payed.

Ex: sheet1
A B C D
E F G
14.08.2009 14.09.2009 14.10.2009 14.11.2009 14.12.2009 14.01.2010
14.02.2010

sheet2:
A B C D
E F G
OK

Rate 1 is payed, and i write ok. The formula to look in range sheet2!A1:G1
and to see that in corresponding cell (A1) is something, so the formula to
work further. If sheet2!A1:G1 was empty, then the formula to display
"please
pay" until i will write something in the corresponding cell.
Sheet1!A1:G1 represent dates when i need to pay
Sheet2!A1:G1 represent the confirmation that i have payed.

Can this be done?
Thanks!