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, 2022 in Database by Edureka
• 13,670 points

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, 2022 by gaurav
• 23,260 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, 2022 in Database by Kithuzzz
• 38,010 points
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, 2022 in Database by narikkadan
• 63,700 points
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, 2022 in Database by Kithuzzz
• 38,010 points
+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,090 points
0 votes
1 answer

Retrieve Balance with VBA and Excel

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

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
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,090 points
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,090 points
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
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, 2022 in Database by gaurav
• 23,260 points
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, 2022 in Database by gaurav
• 23,260 points
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP