Kate,

For dates in column A, starting in cell A2, for example, enter this into B2

=IF(NOW()A2,"Expired","Current")

HTH,
Bernie
MS Excel MVP


"Kate@AF" wrote in message
...
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