Formula

K

Kate@AF

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
 
B

BenjieLop

Kate@AF said:
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
Click to expand...

ASSUME that your dates are in the following cells:

A1 -- date that you want to compare with a date in another column
B1 -- this is the "date that is in the other column"


Your formula will be

=IF(A1>B1,\"CURRENT\",\"EXPIRED\")

Hope this is what you need.


Regards.
 
R

Rowan

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
 
B

Bernie Deitrick

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
 
G

Gord Dibben

Kate

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

cellref is the cell wherein the date is entered.


Gord Dibben Excel MVP
 
Top