year - 1

[alvin Kuiper]

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]

=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).

 

[Gary''s Student]

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

Just be careful about leap years.

 

[alvin Kuiper]

Thanks


Alvin
"Dave Peterson" skrev:

=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).

 

[Dana DeLouis]

Hi.

=EDATE(A1,-12)

Note that this will move a Feb 29 to Feb 28.

Dana DeLouis

 

[macropod]

Hi Alvin,

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