=date(year(a1)-1,month(a1),day(a1))

It'll work for almost every date except the leapyear dates (Feb 29, 2008 won't
give Feb 29, 2007).

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

--

Dave Peterson