Get month() ie. October 4

[nickjar2]

I am using Excel. I can get the Month(date) (obviously for October this will be 10) but how do I actuall get 'October' to return. I could set up an array that held the months of the year, but was wondering if there is an easier way.

Nick

 

[dneufarth]

Use a custom cell format mask of MMMM.

Format->Cells->Number(Tab)->Custom


Dave

 

[nickjar2]

Hi Dave,

Thanks 4 responding. I am not too hot with Excel so could u explain what that would do please?

Nick

 

[DaleWatson123321]

Nick,

I believe your own thought of using an Array was on the right track ...except try using the "Choose" function.

The following formula will work for you ...copy it right from here...

=CHOOSE(MONTH(A1),"January","February","March","April","May","June","July","August","September","October","November","December&quot

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[jebry]

Hi Nick!

To specify Dave's idea:

You need to right click on the cell(s) you want to format. From the pop-up menu choose Format Cells. Click on the Numbers tab. In the list box, choose Custom. In the text box type MMMM. Now the cell will take the date in the the cell and display only the month.

hth Jeff Bridgham
bridgham@purdue.edu

 

[nickjar2]

Superb Dale.

Cheers,

Nick