Thread: 3 months prior and 3 months post a date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default 3 months prior and 3 months post a date
Hi,

Asssuming a properly formatted date in A1 try this

=DATE(YEAR(A1),MONTH(A1)+3,DAY(A1))

Change +3 to -3 for 3 months previous

Mike

"renee" wrote:

My sales training takes place on 2007/10.

How do I get excel to calculate in another column the 3 months prior to this
date and the 3 months post this date.

i.e. 2007/09
2007/08
2007/07
2007/11
2007/12
2008/01


Reply With QuoteReply With Quote