View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vabu3184
 
Posts: n/a
Default conditional formatting with dates

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