Kate

=IF(cellref=TODAY(),"current","expired")

cellref is the cell wherein the date is entered.


Gord Dibben Excel MVP


On Mon, 26 Sep 2005 16:02:02 -0700, "Kate@AF"
wrote:

Hi,

Can you help me here? - I would like to create a formula that automatically
enters either the word "expired" or the word "current" into a column, when it
looks up the date in another column. I would like this column to
automatically tell me whether that row is current or expired, based on the
other column's date. If the date in the column is passed then my new column
should say "expired", and if it is in the future then my new column should
say "current".

I hope this is clear.

Thankyou
Kate