Hello,

How can I use the following formula and return the text format of the date?:

=+MONTH(NOW())&" "&YEAR(NOW())&" Actuals"

Even when I have the cell formatted to MMMM-YYYY, I still get 12 2004
Actuals. I would like it to be displayed as December 2004 Actuals.

Thank You,

the cell where you have yoyr date just go to
Format-custom and paste this
mmmm yyyy "Actuals"
that will change it to "December Actuals" for 12/13/04

"tjh" wrote in message
...
Hello,

How can I use the following formula and return the text format of the
date?:

=+MONTH(NOW())&" "&YEAR(NOW())&" Actuals"

Even when I have the cell formatted to MMMM-YYYY, I still get 12 2004
Actuals. I would like it to be displayed as December 2004 Actuals.

Thank You,

and a formula would be
=TEXT(Now(),"mmmm yyyy Actual")

"tjh" wrote in message
...
Hello,

How can I use the following formula and return the text format of the
date?:

=+MONTH(NOW())&" "&YEAR(NOW())&" Actuals"

Even when I have the cell formatted to MMMM-YYYY, I still get 12 2004
Actuals. I would like it to be displayed as December 2004 Actuals.

Thank You,

=TEXT(TODAY(),"mmmm yyyy")& "Actuals"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"tjh" wrote in message
...
Hello,

How can I use the following formula and return the text format of the
date?:

=+MONTH(NOW())&" "&YEAR(NOW())&" Actuals"

Even when I have the cell formatted to MMMM-YYYY, I still get 12 2004
Actuals. I would like it to be displayed as December 2004 Actuals.

Thank You,