Name of month (easy question)

gbarclay2001 · Apr 11th, 2002, 05:59 AM

Hi all,

I have a cell with todays date using the "=TODAY()" comand. Using this cell I want to have another saying what month we are in ie. "April". Any ideas how I do this?

Many thanks

greg

Aladin Akyurek · Apr 11th, 2002, 06:02 AM

Quote:

On 2002-04-11 04:59, gbarclay2001 wrote:
Hi all,

I have a cell with todays date using the "=TODAY()" comand. Using this cell I want to have another saying what month we are in ie. "April". Any ideas how I do this?

Many thanks

greg

=TEXT(A1,"mmmm")

where A1 contains your TODAY formula.

gbarclay2001 · Apr 11th, 2002, 06:27 AM

Cheers, I don't think I'd ever have found that. I'm sure I'd have got it working some way but it would've been a hell of a lot more complicated than that.

Thanks Again

gbarclay2001 · Apr 11th, 2002, 06:41 AM

Actually I've got another quick question.

Now that I've got my wonderful new month name, how do I incorporate it into a graph heading so it will automaticaly update when we enter a new month?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 11th, 2002, 05:59 AM	#1
gbarclay2001 New Member Join Date: Mar 2002 Location: London Posts: 46	Hi all, I have a cell with todays date using the "=TODAY()" comand. Using this cell I want to have another saying what month we are in ie. "April". Any ideas how I do this? Many thanks greg

Apr 11th, 2002, 06:27 AM	#3
gbarclay2001 New Member Join Date: Mar 2002 Location: London Posts: 46	Cheers, I don't think I'd ever have found that. I'm sure I'd have got it working some way but it would've been a hell of a lot more complicated than that. Thanks Again

Apr 11th, 2002, 06:41 AM	#4
gbarclay2001 New Member Join Date: Mar 2002 Location: London Posts: 46	Actually I've got another quick question. Now that I've got my wonderful new month name, how do I incorporate it into a graph heading so it will automaticaly update when we enter a new month?