Writing a month name from its number
 

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

Writing a month name from its number
 

try this

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

--


Gary

"travis" wrote in message
...
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

Writing a month name from its number
 

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

or even

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

--
__________________________________
HTH

Bob

"travis" wrote in message
...
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