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.