Hi, i have this code:
=IF(Acte!A1="","",IF(TODAY()=Acte!A1,"expired",Ac te!A1-TODAY()))
This code extract a date from A1, but now i have a group of 4 cells with
diferrent dates.
A B C D
01.01.2009 01.03.2009 01.06.2009 01.09.2009

All i need is that the code look in "A1:D1" and if a cell it's bigger than
today, than to take the data from the next cell. Ex: today is 30.06.2009, so
the code to look in "D1" - 01.09.2009.

Can this be done?
Thanks.