Multiple IF conditions with dates, how to

Hello,

what I want to do is have a formula do the following:

If date in A2 is from 1.1.2008 to 31.3.2008 then write "Q1" in A1
If date in A2 is from 1.4.2008 to 30.6.2008 then write "Q2" in A1
If date in A2 is from 1.7.2008 to 30.9.2008 then write "Q3" in A1
If date in A2 is from 1.10.2008 to 31.12.2008 then write "Q4" in A1

Please help me on this one.

thank you very much!

Hello,

I have another problem. I am using these quarters for a table of cash flow.
The thing with only Q1 Q2 Q3 Q4 is only good for one year.
But what if I am expecting some income on 02.Jan.2009, then I would like excel to write Q1-09. Do you see what I mean?
Can that be solved with IF somehow. I think one way would be to just make a list of all dates and then use VLOOKUP, but there's got to be another alternative.

Please advise,

Kind regards

="Q"&CEILING(MONTH(A2)/3,1)&"-"&TEXT(A2,"YY")

Regards

Dav

knowledge of you guys just blows my mind Or it's just my inexperience

Thanks a lot!!