View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alan B Alan B is offline
external usenet poster
 
Posts: 8
Default Subtracting 1 year from todays date

Does anyone know how to subtract from or add to the year in a given date e.g
if today's date is 28 Sep 07 I would like to be able to add 1 and subtract 1
to the year only giving 28 Sep 06 and 28 Sep 08. If I do minus 365 it will
work, but not on leap year dates.

Thanks

Alan