formula

G

Guest

is there any formula I could use so that when i enter the date in coulmn b
the quarter comes up in column a. I am trying to enter if dates between
01/01/2007 and 31/03/2007 equals q1 and then if between 1/4/07 to 30/6/07
then equals q2 etc etc for q3 and q4.
column a column b
q1 3/02/07
Thank you fro your help.
 
C

cubbybear3

Try this (I think it will work):

=IF(MONTH(B1)<=3,"Q1",IF(AND(MONTH(B1)>=4,MONTH(B1)<=6),"Q2",IF(MONTH(B1)>=10,"Q4","Q3")))

-pb
 
J

joeu2004

is there any formula I could use so that when i enter the date
in coulmn b the quarter comes up in column a.

In A1:

="Q" & text(roundup(month(B1)/3,0),"0")
 
R

Rick Rothstein \(MVP - VB\)

is there any formula I could use so that when i enter the date in coulmn b
the quarter comes up in column a. I am trying to enter if dates between
01/01/2007 and 31/03/2007 equals q1 and then if between 1/4/07 to 30/6/07
then equals q2 etc etc for q3 and q4.
column a column b
q1 3/02/07
Thank you fro your help.

This should do it...

="Q"&ROUNDUP(MONTH(B1)/3,0)

Rick
 
R

Roger Govier

Sorry, only just noticed that your dates are in column B, and you want a Q
in from of the quarter number
="Q"&CEILING(MONTH(B1),3)/3
 

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