Day and Month Names

[Guest]

I know I can use month(ref) to get the month number, but is there a function to return the month name? i.e. function(2) = February?
I know I can format the cell as "mmmm" to just display the month on its own, but I need to incorporate it into a string on other text.

 

[Bob Phillips]

RG,

Yes, it's the ubiquitous TEXT function

=TEXT(A1,"mmmm") gives February
=TEXT(A1,"mmm") fives Feb

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

I know I can use month(ref) to get the month number, but is there a

function to return the month name? i.e. function(2) = February?

I know I can format the cell as "mmmm" to just display the month on its

own, but I need to incorporate it into a string on other text.

 

[Paul]

I know I can use month(ref) to get the month number, but is there a

function to return the month name? i.e. function(2) = February?

I know I can format the cell as "mmmm" to just display the month on its

own, but I need to incorporate it into a string on other text.

If you are starting with a date (say in A1), you can use the TEXT function.

For example,
=TEXT(A1,"mmmm")
will give the full name of the month (such as "January").

=TEXT(A1,"ddd")
will give the abbreviated weekday (such as "Wed").

 

[Arvi Laanemets]

Hi

=TEXT(YourDate,"mmmm")
where YourDate is reference to date value, or some function returning date.


--
(When sending e-mail, use address (e-mail address removed))
Arvi Laanemets

I know I can use month(ref) to get the month number, but is there a

function to return the month name? i.e. function(2) = February?

I know I can format the cell as "mmmm" to just display the month on its

own, but I need to incorporate it into a string on other text.