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!