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
• 9,320 points
24 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 Edureka
• 8,820 points

Related Questions In Database

+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,060 points
361 views
0 votes
1 answer

How will I get all the rows from my table where name starts with 's' and ending with 'I'?

Hi Santanu, I understand your problem, You can try ...READ MORE

answered May 28, 2019 in Database by sampriti
• 1,120 points
471 views
0 votes
1 answer

How to set SSL to Domain name for MYSQL database

Hello @ Lakshminarayanan, Yes, It is possible to setup ...READ MORE

answered Jul 9, 2020 in Database by Niroj
• 82,680 points
408 views
0 votes
2 answers

How to send data to my database from html and css Contact Us Form?

Hello @Sign, It is simple to create contact ...READ MORE

answered Aug 4, 2020 in Database by Niroj
• 82,680 points
15,538 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
323 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,060 points
289 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,060 points
3,129 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,517 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 Edureka
• 8,820 points
26 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 Edureka
• 8,820 points
34 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP