Bob, I had thought about -4 rather than -1, but his example of
Jul 07 Jun 07
Feb 08 Mar 08
etc.

rather threw all options, so I had decided his examples were not real.

You are probably correct though, and he may just have missed out one of
his months in the second set of values

--
Regards

Roger Govier


"Bob Phillips" wrote in message
...
I think he wants

=DATE(YEAR(A1),(INT((MONTH(A1)-4)/3)+1)*3,1)

formatted as mmm-yy

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Roger Govier" wrote in message
...
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