I have a column of dates and I need a formula that will check to see what
month the date is in and then put text in another cell depending on what the
result is. So, if the date in A1 is in January then B1 = "text1", if A1
date is in February then B1="text2"...and so on for all months.

Also, I would need another formula that will do the same, except I need it
to look at a specific date range, instead of just the month. Like 1/15/07
through 2/28/07.

The dates in the column are formatted as mm/dd/yyyy

Thanks for the help.