the month function gives me 1 for the value of month(today()), can i get
january instead?

thanks.

jim

microsoft.public.excel.newusers

Just use
=TODAY()
And custom format the cell to
mmm
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"jim sturtz" wrote in message
...
the month function gives me 1 for the value of month(today()), can i get
january instead?

thanks.

jim

microsoft.public.excel.newusers

Try this:

=TEXT(TODAY(),"mmmm")

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"jim sturtz" wrote:

the month function gives me 1 for the value of month(today()), can i get
january instead?

thanks.

jim

microsoft.public.excel.newusers

Hi Jim,

Try this formula:
=CHOOSE(MONTH(TODAY()),"January","February","March ","April","May","June","July","August","September" ,"October","November","December")

Cheers,

Kevin Lehrbass

www.spreadsheetsolutions4u.com


"jim sturtz" wrote:

the month function gives me 1 for the value of month(today()), can i get
january instead?

thanks.

jim

microsoft.public.excel.newusers

whatta group, now which do i take door#1 or ....

thanks.

"jim sturtz" wrote in message
...
the month function gives me 1 for the value of month(today()), can i get
january instead?

thanks.

jim

microsoft.public.excel.newusers