Thanks guys. But the examples are real. What I wanted is if there is a
month which falls outside the designated quarter months, then it should
revert back to one of the quarter months So you could have any set of
scenarios of dates falling outside the quarter months. For example if
the date is in july, or august it should revert back to either June or
september. Or if the date is january or February it should revert back
to either December or March as quarter period.

This is an acutal scenario.





LR wrote:
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