On Sun, 26 Mar 2006 16:43:02 -0800, Vabu3184
wrote:

I am trying to write a wine spreadsheet and would like to have one column
that indicates the year the wine is ready to drink.

I have entries about using TODAY() to indicate dates before the current
date, however I am struggling to get it to recognise the conditions when the
entry in the cell is only the year.

Eg. 2005

Can someone please help me with indicating entries where the value (as a
year) is less than the current date?

Thanks

With the year in A1:

=A1<YEAR(TODAY())


--ron