In D1:
0
In D2:
2/15/2008
In D3:
4/1/2008
etc
In D9:
12/31/2008
In E1:
=TEXT(D1,"mmdd")
Copy down to E9
In F1:
FHFQ
In F2:
SHFQ
etc
Now your search formula is:
=VLOOKUP(TEXT(A1,"mmdd"),$E$1:$F$9,2)
Copy down as far as you need

You may have different definitions of the beginning of a quarter; 14th, 15th or 16th of the month. Change table in column D
accordingly.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Learning Excel" wrote in message
...
| 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.