Hello:

I have a column that has dates in it in the format of "MM/DD/YY".
I'd like to create a formula that would evaluate this column and return a
value based on the following conditions.

If, lets say "B2" (the date) is less than or equal to DATEVALUE("01/02/09")
and more or equal to DATEVALUE("01/01/10") return the year value of teh "B2"
cell.
Not sure if there is a way but the rest of the dates fall withing 2009 for
which I need to return the year and quarter...ie. 2009 Q1; 2009 Q2 thorugh
Q4. It might not work all within one formula but as far as I get the first
part that would help. I can just manually do the 2009 then.

Thank you.
Monika