Reply to thread

Message: [QUOTE="Jim Cone, post: 3869514"] First make sure that the I6 cell is formatted as a Date. -then- Put the "12/31/2009" date (without the quote marks) in another cell and reference the cell... =IF(I6>B1,"NEW STAFF","") -or use- =IF(I6>DATEVALUE("12/31/2009"),"NEW STAFF","") -- Jim Cone Portland, Oregon USA [URL]http://www.contextures.com/excel-sort-addin.html[/URL] (sorting add-in) .. .. .. "Debbie" <debbiep@ywcaofjamestown.com> wrote in message I am trying to get a formula to put in the cell "New Staff" if the date is >12/31/09 but blank if false. This is the formula I am using. Can you maybe tell me what I am doing wrong? =IF(I6>"12/31/2009","NEW STAFF","") I6 is a lookup formula putting the hire date in I6 cell. The lookup formula is: =IF(ISERROR(VLOOKUP($A6,'2010'!$A$1:$W $314,5,FALSE)),"",VLOOKUP($A6,'2010'!$A$1:$W$314,5,FALSE)) Hope this all makes sense. Thanks in advance. Debbie [/QUOTE]