If statement using current year

[MelanieB]

Column B is a list of years (ex: 1998, 2001, 2001, 2010).
In column F, I want to write an if statement that says if the value in column B is less than the current year, then return the value of 1, otherwise return a zero.

I'm stuck.. I know how to do that using Today(), but is there something like that for looking at the current system date and using just the year?

I tried this in F2:
=IF(B2<TODAY(),1,0)

but it returns a 1 when the year 2010 is in column B, and in that case I want the value of 0.

[Argus]

It's quite late over here, but how about:
=IF(B2<YEAR(TODAY()),1,0)
(Year returns the year corresponding to a date.)

[sdckapr]

=IF(B2<year(TODAY()),1,0)

Steve

[HansV]

Or even

=1*(B2<YEAR(TODAY()))

[MelanieB]

That worked perfectly! Thank you.