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