Thread: Quarter Dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LR LR is offline
external usenet poster
 
Posts: 5
Default Quarter Dates

I have a column A which can have different dates.
As


July 07
Feb 08
Apr 08
May 08
Oct 08
Nov 09

In column B I would like to have dates that correspond to the quarterly
periods Dec, March,
June,September.

For example in column B, I would like to see

June 07
March 08
march 08
June 08 etc.

Is there a formula that could be applied to column B to get the dates
as above.

Thanks