Hi,
I was wondering if anyone could please help me.

I'm trying to set up a formular that says if A1 (which is a date) is between 01/01/2012-31/12/12 then B1 will say "2012".
If A1 is between 01/01/2013-31/12/2013 then B1 will say "2013" and so on.

Can anyone suggest the best way of doing this?

Thanks,

Jon.