Date Format

[tjh]

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,

 

[N Harkawat]

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

 

[N Harkawat]

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

 

[Bob Phillips]

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

--

HTH

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