Matching Quarters

L

LR

I have the first column with various dates.



Col A

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

and so on.

What I want to do in col B - is to convert the dates to fall into any
of the following quarters December , March, june,September

This is what I want Col B to look like corresponding to column A

June 07
Dec 07
March 08
march 08
September 08
September 09

Is there a formula which can give the dates automatically in column B
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Quarter Dates 8
index_match 5
XIRR Function - large IRRs 1
2 dimensional date sort 1
SumProduct with dates 4
When building a chart Dates are been included that are not in thedate range 1
sumif 2
Excel Formula 1

Top