IF/ELSE HELP Needed with Dates

[terrisol13]

Hello,

I need some help. I'm basically trying to say:

If my date in cell BE11 is prior to 11/16/2011 then its "Past due". If the date is after 12/16/2011 then its "Current". And if the date is neither of those two then its "Within a month".

Here's what I have:

=IF(BG11<DATE(11,16,2011),"Past due",IF(BG11>DATE(12,16,2011),"Current","Within a month"))

Right now I have a date of 9/12/2011 and it says "Current", when I toggle the sign to be >, its shows "Past due". But then when I go to change my date in BE11 to, for exmaple, 3/12/2012, it never changes to "Current". I'm missing something! Appreciate any help!

[brokenbiscuits]

I believe the DATE function has to be in the syntax (year, month, day)

Try:
=IF(BG11<DATE(2011,11,16),"Past due",IF(BG11>DATE(2011,12,16),"Current","Within a month"))

[6StringJazzer]

DATE takes (year, month, day). Try this:

=IF(BG11<DATE(2011,11,16),"Past due",IF(BG11>DATE(2011,12,16),"Current","Within a month"))

[terrisol13]

Thank you both SO very much!! It worked!!