Help with an IF Formula

[Debbie]

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

 

[Don Guillett Excel MVP]

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

=IF(I6>DATEVALUE("12/31/2009"),"NEW STAFF","")

 

[Jim Cone]

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
http://www.contextures.com/excel-sort-addin.html
(sorting add-in)

..
..
..

"Debbie" <[email protected]>
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

 

[Pete_UK]

You could also try this:

=IF(I6>--"12/31/2009","NEW STAFF","")

as long as the date is in the format you normally use on your PC. The
double minus converts text into a numeric value.

Hope this helps.

Pete

 

[Dave Peterson]

One more:

=if(i6>date(2009,12,31), ...

I'm always afraid of using datevalue and strings. I'm not sure how excel (and
different locales) will treat: 01/02/03

January 2, 2003
February 3, 2001
or what???

I know how =date() will work.

 

[Debbie]

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  USAhttp://www.contextures.com/excel-sort-addin.html
(sorting add-in)

.
.
.

"Debbie" <[email protected]>
wrote in messageI 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

Thanks, this worked perfect. You guys are awesome.