Bucketing cells with dates based on predefined ranges

Hi guys,

I hope you can help me.

I have a column with dates like:

09/15/2011
09/21/2011
09/30/2011

I want to add a column right next to this one in order to bucket these dates based on predefined ranges.
The ranges are for instance:

09/15/2011-09/20/2011= phase 1
09/21/2011-09/29/2011= phase 2
09/30/2011-10/05/2011= phase 3
10/06/2011-10/15/2011= phase 4

I would like to use a formula that would work like this:

If the date in the cell on the left is between 09/15/2011-09/20/2011 then label this cell as “phase 1”. If it is between 09/21/2011-09/29/2011 → “phase 2”; If it is between 09/30/2011-10/05/2011 → “phase 3”; if it is between 10/06/2011-10/15/2011→ phase 4

I hope it is clear. If not let me know. Thanks.

Regards,

I attached the excel file as maybe my post was not that clear.

thank you! it works!

welcome, glad to hear. Btw, you could also click the little star at the bottom left of my post to express your satisfaction with the response