Thread: Function to reduce date by 3 months
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
mike h mike h is offline
external usenet poster
  
Posts: 1
Default Function to reduce date by 3 months
Hello, I need a reasonably simple function that will look at a date (which
will always be the 1st of a month) and return the equivalent date a
specified number of months earlier. e.g we give it the 1st of Feb 03, and it
returns the 1st of November 02.

Ideally I wouldn't have to use a user-defined VBA function, but find a way
to do it using the existing date functions. VBA is a last resort for this
spreadsheet.

Thanks


Reply With QuoteReply With Quote