How to extract month name from custom date

0 votes

I have a CSV file which has date in mm/dd/yyyy format in column A. Here are the steps that i took to extract month from it.

  1. Select the entire column A and click on Format Cells
  2. In Format Cells, Click on Custom and used the string mm/dd/yyyy there
  3. Clicked Ok
  4. On column D (or any other column), I entered the following text =TEXT(A1, "mmmm"). This text is supposed to extract month number from column A1 and convert into month. But it just copies the whole date there.

What i am missing here?

Apr 5 in Database by Edureka
• 13,640 points
133 views

1 answer to this question.

0 votes

The steps to accomplish so are as follows:

Select all of the cells that have dates for which the month name should be displayed.
Go to the Home tab.

Click the Home tab
Click the dialogue box launcher icon in the Number group (or use the keyboard shortcut Control +1). The Format Cells dialogue box will appear.

Click on Format Cells open dialog box launcher
Select Custom from the Category drop-down menu.

Click on Custom option in Fomat Cells dialog box
Enter'mmmm' in the type field. In the Sample preview, you should see one of the month names.

Enter mmmm as the custom number format

Select OK.
All of the dates would be converted to their complete month names using the processes above (as shown below).

Date showing only the month name

answered Apr 5 by gaurav
• 22,040 points

Related Questions In Database

0 votes
0 answers

How to group by month from Date field using sql

How can I only group by month ...READ MORE

Aug 20 in Database by Kithuzzz
• 20,660 points
281 views
0 votes
1 answer

How to extract only the year from the date in sql server 2008?

To obtain the year from the given ...READ MORE

answered Sep 15 in Database by narikkadan
• 37,660 points
97 views
0 votes
0 answers

How to return only the Date from a SQL Server DateTime datatype

SELECT GETDATE() Returns: 2008-09-22 15:24:13.790 I want that date part ...READ MORE

Sep 6 in Database by Kithuzzz
• 20,660 points
84 views
+2 votes
1 answer

How to export data from MySql to a CSV file?

If you are using MySql workbench then ...READ MORE

answered Jan 4, 2019 in Database by Priyaj
• 58,100 points
593 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
450 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,100 points
395 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,100 points
3,367 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
2,830 views
0 votes
1 answer

how to change format of date from mm/dd/yyyy to dd-mmm-yyyy in MS Excel

First, pick the cells that contain dates, ...READ MORE

answered Apr 11 in Database by gaurav
• 22,040 points
56,095 views
0 votes
1 answer

How to sort dates from Oldest to Newest in Excel?

Drag down the column to select the ...READ MORE

answered Feb 23 in Database by gaurav
• 22,040 points
423 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP