date with if() is not working

[lezawang]

Hi
I have this formula =IF(A1<1/9/2016,"",A1) which does not work. However, if i save the date 1/9/2016 in a cell, lets say H1 and do this formula again but instead of the date 1/9/2016, i put H1. thank you<h1,"",a1)....<h1,"",a1)...<h1,"",a1).<h1," ",a1)
<h1,"",a1), it="" will="" work,="" why="" is="" that?="" thank="" you="" so="" much
<h1,"",a1), that="" would="" work.="" why="" is="" that?="" thank="" you="" so="" much


(column A) .............(column B)
Joining date ............Testing
1/1/2001 ................=IF(A1<1/9/2016,"",A1)
2/2/2009 ................=IF(A2<1/9/2016,"",A2)
2/3/2017 ................=IF(A3<1/9/2016,"",A3)
3/6/2002 ................=IF(A4<1/9/2016,"",A4)</h1,"",a1),></h1,"",a1),></h1,"",a1)....<h1,"",a1)...<h1,"",a1).<h1,">

 

[dreid1011]

Hi
I have this formula =IF(A1<1/9/2016,"",A1) which does not work. However, if i save the date 1/9/2016 in a cell, lets say H1 and do this formula again but instead of the date 1/9/2016, i put H1. thank you<h1,"",a1)....<h1,"",a1)...<h1,"",a1).<h1," ?,a1)
<h1,"",a1), much
<h1,"",a1), much


(column A) .............(column B)
Joining date ............Testing
1/1/2001 ................=IF(A1<1/9/2016,"",A1)
2/2/2009 ................=IF(A2<1/9/2016,"",A2)
2/3/2017 ................=IF(A3<1/9/2016,"",A3)
3/6/2002 ................=IF(A4<1/9/2016,"",A4)</h1,"",a1),></h1,"",a1),></h1,"",a1)....<h1,"",a1)...<h1,"",a1).<h1,">

How is this "not working"? I copied your sample data and it seems to be working as the formula is intended. I just had to format col B as date.

Edit: Nvm, I see all entries save #3 are not returning blanks.

The formula does not recognize 1/9/2016 as a number to compare vs the values in col A. Therefor, you must format it properly in the comparison to work. Such as:

=IF(A1 < DATEVALUE("1/9/2016"),"",A1)

<datevalue("1 9="" 2016?),??,A1)

Or

=IF(A1 < DATE(2016,1,9),"",A1)

Mind the spaces in the above formulas around the " < " sign.</datevalue("1>