If Less than or Equal or for Date is give me wrong results

[zunaib]

I have a tab in Excel named Admin Input. In Cell B5 I have a date 12/31/2015

[TABLE="width: 295"]
<tbody>[TR]
[TD]Begin Date of Fiscal Year[/TD]
[TD="align: right"]7/1/2015[/TD]
[/TR]
[TR]
[TD]End Date of Base Period[/TD]
[TD="align: right"]12/31/2015[/TD]
[/TR]
[TR]
[TD]2 Years Ago FY[/TD]
[TD="align: right"]2014[/TD]
[/TR]
[TR]
[TD]Last FY[/TD]
[TD="align: right"]2015[/TD]
[/TR]
[TR]
[TD]Current FY[/TD]
[TD="align: right"]2016[/TD]
[/TR]
[TR]
[TD]Budget FY[/TD]
[TD="align: right"]2017[/TD]
[/TR]
</tbody>[/TABLE]


I have another tab on the same file named as Input

In Column F it's showing the people's start date as below:

Now in Column L I have the below formula:

=IF(F14<='Admin Input'!$B$5, "Estalished", "New")


[TABLE="width: 108"]
<tbody>[TR]
[TD]11/27/1989[/TD]
[/TR]
[TR]
[TD]07/07/1980[/TD]
[/TR]
[TR]
[TD]Not In HR Cube[/TD]
[/TR]
[TR]
[TD]03/10/2014[/TD]
[/TR]
[TR]
[TD]Not In HR Cube[/TD]
[/TR]
[TR]
[TD]07/01/2009[/TD]
[/TR]
[TR]
[TD]10/28/2013[/TD]
[/TR]
[TR]
[TD]07/01/2007[/TD]
[/TR]
[TR]
[TD]Not In HR Cube[/TD]
[/TR]
[TR]
[TD]07/01/1989[/TD]
[/TR]
[TR]
[TD]07/01/1977[/TD]
[/TR]
</tbody>[/TABLE]


Now in Column L I have the below formula:

=IF(F14<='Admin Input'!$B$5, "Established", "New")


So it should technically bring "Established" for all the rows but is's bringing "New"


Pleas help


Thanks,

Z

 

[MarcelBeug]

Probably the dates in column F aren't formatted as date.

 

[zunaib]

Thank You Marcel. Actually when I refreshed the excel it gave me the correct results. Yes the formatting was the first thing I checked, still it was giving me the same wrong results. But I appreciate you responding

 

[MarcelBeug]

You're welcome. Appreciate your feedback.