Hi

Try entering in B1
=TEXT(DATE(YEAR(A1),(INT((MONTH(A1)-1)/3)+1)*3,1),"mmm yy")
and copy down
--
Regards

Roger Govier


"LR" wrote in message
ups.com...
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