Filter Column J and then...

[siobeh]

Hi Forum Experts,

Could you please help me with my problem.
I have a column with dates (Column J), and:

If that contains months "January, February & March" then in Column K (parallel of it) will be tag as "Q1 2014".

If that contains months "April, May & June" then in Column K (parallel of it) will be tag as "Q2 2014".

If that contains months "July, August & September" then in Column K (parallel of it) will be tag as "Q3 2014".

If that contains months "October, November & December" then in Column K (parallel of it) will be tag as "Q4 2014".

I have attached my file.
Thank you in advance!

[AB33]

Siobeh,
I do not know how your format your dates.
Look at the attached!
You get 2 different result depending on the format of a cell.
The first code result is in column K, and the second on column L.

[siobeh]

Hi AB,

Thanks for the reply.
This is my format of my dates: 3/14/01

All dates where displaying "Q1 2014".

[siobeh]

Hi AB33,

I've recheck again and the result Column L is what I'm looking for. Thank you so much! :D I can sleep now. Yipee!