Can someone help with my logic? I can't seem to figure this out.

I want it to say "2005" if the date is between 12/31/2004 and 01/01/2006. I
keep getting an error.

Here is my formula.

IF((AND(D2DATE(2004,12,31)),(D2<DATE(2006,1,1))), "2005","NO")