Dates in formula

[gncntry96]

My formula:
=IF(AND(E18>=1/1/2007,E18<=12/31/2007,E18+180, " ")

The problem:
It's returning false, even though my E18 date is 3/15/2007. I have formatted E18 as a date mm/dd/yyyy so I'm not sure why the problem. When I look at the function arguments, the first part shows true, the second shows false.

Any thoughts?
Thanks!

 

[barry houdini]

You need to do this

=IF(AND(E18>="1/1/2007"+0,E18<="12/31/2007"+0),E18+180,"")

or for complete unambiguity use DATE function

=IF(AND(E18>=DATE(2007,1,1),E18<=DATE(2007,12,31)),E18+180, " ")

....although in this particular case if you just want to check whether the date is in 2007 you can use YEAR function, i.e.

=IF(YEAR(E18)=2007,E18+180,"")

 

[gncntry96]

Perfect!!! Thanks so much!