P

#### puiuluipui

{=IF(COUNT(sheet1!A1:G1),IF(TODAY()>=MAX(sheet1!A1:G1),"Expired",INDEX(sheet1!A1:G1,,MIN(IF(sheet1!A1:G1>TODAY(),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!