Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula
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 |
#2
|
|||
|
|||
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 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(A1B1,\"CURRENT\",\"EXPIRED\") Hope this is what you need. Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=470951 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |