Hi macropod,

Firstly, many thanks for the promt response.

Having put the formula in it gives a date of 31/12/2007 and not 31/12/2006
as I want.

ANy ideas what needs to be changed.

Pank

"macropod" wrote:

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.