Hello -

Range C3:C100 have dates (MM/DD/YY format) listed. I am looking for a formula to enter in B3:B100 that will check C3:C100; if it is between 01/01/07 & 01/31/07, it will put "January" as the result; if it is between 02/01/07 & 02/28/07 it will put February as the result; if it is between 03/01/07 & 03/31/07 it will put March as the result; this would continue through December. Is there a way for me to nest many IF statements to accomplish this or is there another formula that would accomplish this?

I am using 2003.

Thank you!