Month Function

[nc]

I am running Excel 2000.

Has anyone got a Month function returning the month from
the date rather than the month number.

Thanks.

 

[Andy Brown]

Has anyone got a Month function returning the month from

the date rather than the month number.

Probably. If not, you could use VLOOKUP in a formula, along the lines of

=VLOOKUP(B1,{1,"Jan";2,"Feb";3,"Mar";4,"Apr"},2)

HTH,
Andy

 

[Bill Kuunders]

I have used

=TEXT(C15,"MMM")
as a conversion of a normal date in cell C15

regards
Bill K

 

[Andy Brown]

Apols ; I meant (e.g.)

=VLOOKUP(MONTH(A1),{1,"Jan";2,"Feb";3,"Mar";4,"Apr"},2)

, where A1 houses the date.

Rgds,
Andy

 

[William]

I don't know if this works in XL 2000......

MsgBox MonthName(Month(Range("A1")))

--
XL2002
Regards

William

(e-mail address removed)

| I am running Excel 2000.
|
| Has anyone got a Month function returning the month from
| the date rather than the month number.
|
| Thanks.
|

 

[Norman Harker]

Hi nc!

A simple way to return the month name as text is:

=TEXT(MONTH(A1)*29,"mmmm")

As you know, MONTH returns the month number. Also, date serial numbers
represent the number of days from 31-Dec-1899

Date serial number 1*29 is 29-Jan-1900
Date serial number 2*29 is 27-Feb-1900
....
....
Date serial number 12*29 is 13-Dec-1900

What you get if you multiply the month number by 29, is a series of
dates in consecutive months of 1900

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.