I'm trying to calculate a formula in Excel using the IF function. Here is my
code.

=IF(B2=9/1/2006,5,IF(B2=6/1/2006,4,IF(B2=3/1/2006,3,IF(B2=1/1/2006,2,IF(B2=9/1/2005,1,0)))))

Basically this is what I want returned.

If B2=9/1/2006 then it equals 5
If B2=6/1/2006 then it equals 4
If B2=3/1/2006 then it equals 3
If B2=1/1/2006 then it equals 2
If B2=9/1/2005 then it equals 1

I have a feeling the my setup in the formula is rubbish. But what is making
me scratch my head the most is that it worked perfectly fine before! Any
help would be ultra appreciated. Thank you much! Have a nice day.