First, the display formatting of L2 has nothing to do with the value
stored in it, so changing its number format won't affect the formula
(other than using Text).

one way:

=IF(AND(L2DATE(2005,12,1), L2<=DATE(2006,2,28)),J2,0)


In article ,
"TJAC" wrote:

This is a formula I have in my Excel spreadsheet that is not working
correctly.

=IF(AND("12/1/05"<L2,L2<="2/28/06"),J2,0)

This formula works correctly with numbers, but not with dates. I have the
L2 cell format as a date. This formula will return 0 when the date in L2 is
12/20/05 for example.

If someone could help me with this formula I would really appreciate it.