Extracting the month as text from a date

[Ron Matthews]

I have a large spreadsheet of which two of the columns are :

[TABLE="width: 178"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Date Payable [/TD]
[TD] Month[/TD]
[/TR]
[TR]
[TD="align: right"]22-Sep-16[/TD]
[TD] Sep[/TD]
[/TR]
[TR]
[TD="align: right"]27-Mar-17[/TD]
[TD] Mar[/TD]
[/TR]
[TR]
[TD="align: right"]22-Sep-17[/TD]
[TD] Sep[/TD]
[/TR]
[TR]
[TD="align: right"]07-Oct-16[/TD]
[TD] Oct[/TD]
[/TR]
</tbody>[/TABLE]

The dates are in number format in col 1

In col 2 I would like the text value of the month shown in the cell in col 1

I will be grateful for some help please

 

[Scott T]

If the date is a Excel date then in column 2 put =A2 , where A2 has the date. Then format column 2 to say the month. In format cells go to custom and enter mmm

 

[Ron Matthews]

Terrific - thank you so much - I was making it too hard for myself!