I have the following formula in a cell:-

=IF($A$4="spring",DATEVALUE("31-12-06€�),FALSE), which works fine.

However to make the formula more flexible, I dont want to hard code the
year. Basically the year part should be current year minus 1 (i.e. 2007-1).
Please note that the date in the DateValue field will always be 31st December
current year -1

Can someone advise me how I can do that?

Thank you.