Hi Les,

I don't think you tested that.
Certainly not for 8 half quarters (with Excel 2003 and older), but apparently not even for (example) Feb 17, I think.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"WLMPilot" wrote in message ...
|I don't know what all your date ranges will be, but this should get you
| started and I don't know if you need it for the entire year:
|
| A1: Date
| B1: (formula)
|
=IF(AND(A1=DATEVALUE("1/1/2008"),A1<=DATEVALUE("2/15/2008")),"FHFQ",IF(AND(A1=DATEVALUE("2/16/2008"),A1<=DATEVALUE("3/1/2008")),"FHSQ","NOTHING")
|
| To continue this out, replace "NOTHING" with the IF statement as shown for
| the previous check and continue until you have covered all quarters.
| Example, if I just wanted to cover FHFQ - SHSQ, the formula would look like
| this:
|
|
=IF(AND(A1=DATEVALUE("1/1/2008"),A1<=DATEVALUE("2/15/2008")),"FHFQ",IF(AND(A1=DATEVALUE("2/16/2008"),A1<=DATEVALUE("3/1/2008")),"FHSQ",IF(AND(A1=DATEVALUE("3/2/2008"),A1<=DATEVALUE("4/15/2008")),"SHFQ","SHSQ)
|
| Obviously, adjust the dates as needed.
|
| Les
|
|
|
|
|
|
| "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.