=DATE(YEAR(A1)-1,MONTH(A1),DAY(A1))

Just be careful about leap years.
--
Gary''s Student - gsnu200853


"alvin Kuiper" wrote:

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