Hi, i have a problem with this code:
=IF(NOT(SUMPRODUCT(--(Sheet1!A1:G1=TODAY()),--(Sheet2!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()),""))

If in sheet1!A1:G1, the last date is 01.08.2009, a date that has past, and
next cell is empty, the formula is not showing me "expired".I need the
formula to show me "expired" when it found the first blank cell.
EX:
A1 145/01.06.2009
B1 258/01.07.2009
C1 298/01.08.2009
D1 401/01.09.2009
E1

Cell E1 is empty.
If sheet2!D1 is empty, than the code to display "Please pay"
If sheet2!D1 has some numbers in it, than the code to display "expired"
because Sheet1!E1 is empty.
Can this be done?
Thanks!