An alternate way would be to use this formula

=IF(MONTH(A1)<=3,"FHFQ",IF(MONTH(A1)<=6,"FHSQ",IF( MONTH(A1)<=9,"SH1Q","SHSQ")))

where A1 contains the date.
--
HTH,
Barb Reinhardt



"Learning Excel" wrote:

I'm in need of a very specific formula please.
A1 to A100 are all different dates as 02/17/08 ( m,d,y) (could also omitt
the year)
B1 to B100 will be formulas ( of course I just need B1 formula so I copy it
down)
Something like : if A1=1/2/08
B1 will show "FHFQ"
-- Probably it has to show in C1 as B1 has the formula (well, it doesn't
matter to me either way).
FHFQ means "first half first quarter" of the year of course.
So everytime a date is enter in A1 to A100, B or C columns(as you wish) will
show the previous text if dates are from 1/1/8 to 2/15/08.
If I enter 3/1/08 then it will show "SHFQ" meaning "second half of first
quarter".
It's very complicated to me because the need of setting a range in the
formula and also how the text will appear accordinly to the range the date
is in.
By the way the year does not matter as is the same for me any year.
Just the day and the month.
Thanks a lot in advance.

Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.