Thread: year - 1
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
alvin Kuiper alvin Kuiper is offline
external usenet poster
 
Posts: 175
Default year - 1

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