Calculating Month Name
 

Hi,

I need a formula that takes a date function and returns the name of the
month in a string format. Month(c2) returns the number 8, but I would like it
to return the string "August".

Thanks,
RA

=TEXT(C2,"mmmm")

Vaya con Dios,
Chuck, CABGx3




"RestlessAde" wrote in message
...
Hi,

I need a formula that takes a date function and returns the name of the
month in a string format. Month(c2) returns the number 8, but I would like
it
to return the string "August".

Thanks,
RA

Hi!

Try this:

=TEXT(C2,"mmmm")

Biff

"RestlessAde" wrote in message
...
Hi,

I need a formula that takes a date function and returns the name of the
month in a string format. Month(c2) returns the number 8, but I would like
it
to return the string "August".

Thanks,
RA