Hi Kate

Assuming your dates are in column A, in B2 enter the formula:
=IF(A2<TODAY(),"Expired","Current")
and copy down.
Note this formula is volatile i.e it will recalculate every time any
change is made to the workbook as well as when the book is opened and
closed.

Hope this helps
Rowan

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