Nesting IF statements

**VBA Noob** · 10-03-2007, 03:20 PM

Maybe

=TEXT(MONTH(C3),"mmmm")

VBA Noob

**penny** · 10-03-2007, 03:44 PM

Thank you for your quick response!

I tried what you suggested, however, it's always returning January as the answer, regardless of the month it's in.

If I do =MONTH(C3) (or C4, C5, etc.), it does return the correct numerical month (i.e. 2 for February, 9 for September, etc.).

**VBA Noob** · 10-03-2007, 03:50 PM

Sorry,

Didn't test.

Quickest way is enter =C3 in B3 then custom format as "mmmm"
or you could use

=CHOOSE(MONTH(C3),"January","February","March","April","May","June","July","August","September","October","November","December")

VBA Noob