|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
year - 1
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).
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
|