Month Function

  • Thread starter Thread starter nc
  • Start date Start date
N

nc

I am running Excel 2000.

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

Thanks.
 
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
 
I have used

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

regards
Bill K
 
Apols ; I meant (e.g.)

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

, where A1 houses the date.

Rgds,
Andy
 
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.
|
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top