Hi Alvin,

Here's one that'll handle leap years:
=MIN(DATE(YEAR(A1),MONTH(A1)-{12,11},DAY(A1)*{1,0}))

--
Cheers
macropod
[Microsoft MVP - Word]


"alvin Kuiper" wrote in message ...
Hi

Is there a way in a worksheet - Functions where i can
take a cell value (date) and make it a year less
like 01-11-2009 (danish date) shall be 01-11-2008

I can in VB, but can't find it in a waotksheet

alvin