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