Writing a month name from its number

[travis]

If I evaluate month(7/7/2008) I get the number 7.

Apart from a whole bunch of nested if statements or something, how
would I get "July" instead?

Is there a built in function that does that?

This is in the context of a formula:

="Asset based fee for "&MONTH(B2)&" "&YEAR(B2)

Which displays "Asset based fee for 7 2008", where I'd like it to say
"Asset based fee for July 2008".

Travis

 

[Gary Keramidas]

try this

="Asset based fee for "& TEXT(B2,"mmmm") &" "& TEXT(B2,"yyyy")

 

[Bob Phillips]

="Asset based fee for "& TEXT(B2,"mmmm yyyy")

or even

=TEXT(B2,"""Asset based fee for ""mmmm yyyy")