ExcelBanter - Getting the month out

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Getting the month out (https://www.excelbanter.com/excel-discussion-misc-queries/60136-getting-month-out.html)

andy wilson

Getting the month out

Hi,

In A1 i've got 31-dec-2005 as a date

I need to get the month as text into A6 ie dec

Any ideas?
--
Cheers

Andy

Getting the month out

Hi

Try this in A6:
=TEXT(A1,"mmm")

Andy.

"andy wilson" wrote in message
...
Hi,

In A1 i've got 31-dec-2005 as a date

I need to get the month as text into A6 ie dec

Any ideas?
--
Cheers

Andy

Stephen

Getting the month out

"andy wilson" wrote in message
...
Hi,

In A1 i've got 31-dec-2005 as a date

I need to get the month as text into A6 ie dec

Any ideas?
--
Cheers

Andy

=TEXT(A1,"mmm")
will give you Dec

Or
=TEXT(A1,"mmmm")
will give December

Roger Govier

Getting the month out

Hi Andy

One way
=A1 FormatCells.NumberCustom mmm

Regards

Roger Govier

andy wilson wrote:
Hi,

In A1 i've got 31-dec-2005 as a date

I need to get the month as text into A6 ie dec

Any ideas?

All times are GMT +1. The time now is 06:28 PM.