4 SETS OF CRITERIA USED TO DISPLAY ANSWER

M

Mally

Hi

I have a list of dates in column C e.g. 01/10/2008

Column D equals the dates in column C and are formatted using the custom
'mmm' e.g. Oct

What I need is a formaula in column E that shows

If D1=Apr, May or Jun then the formula result displays "Q1"
OR
If D1=Jul, Aug or Sep then the formula result displays "Q2"
OR
If D1=Oct, Nov or Dec then the formula result displays "Q3"
OR
If D1=Jan, Feb or Mar then the formula result displays "Q4"

The formaula will be copied down the column

Thank you in advance.
 
S

Satti Charvak

hi Mally,

use this formula:

=IF(MONTH(A1)<4,"Q4",IF(MONTH(A1)<7,"Q1",IF(MONTH(A1)<10,"Q2","Q3")))
 
S

Satti Charvak

to be more correct for your case, it should be:

=IF(MONTH(C1)<4,"Q4",IF(MONTH(C1)<7,"Q1",IF(MONTH(C1)<10,"Q2","Q3")))

It doesnot matter with the month formula, whether you pick the date from
column "C" or "D".
 
M

MartinW

Hi Mally,

Try this in E1 and dragged down

=LOOKUP(MONTH(D1),{0,4,7,10,13},{"Q4","Q1","Q2","Q3"})

HTH
Martin
 

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

Top