Hi Pank,

Try:
=IF($A$4="spring",DATE(YEAR(TODAY()-1),12,31),FALSE)

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Pank" wrote in message ...
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.