top of page

Convert a date to month as text | Microsoft Excel | Xyclos


Convertir fecha: Año, Mes o día a texto | Microsoft Excel | Xyclos

We are going to learn how to display and how to extract the month from a date, along with other examples that include the day and year.

Excel: how to display a Date as a Month

Let's learn how to display a date as month text using the Text function:

  1. In cell A1 enter a date: 12/6/2022 (mm/dd/yyyy)

    1. Make sure the date aligns right in the cell.

    2. That means that Excel recognizes it as a date or value.

    3. If it is aligned to the left, it is recognized as text and cannot be used to make the conversion.

  2. In cell B1 enter the function: =TEXT(A1,"mmm")

  3. In cell B1 the result is displayed: Dec

Structure of the TEXT function


The Text function has two arguments.

TEXT (Cell that contains a date or value, Format between quotes that you want to apply)

Let's look at other cases.


Display the full name of the month

  1. In cell A1 enter a date: 12/6/2022

  2. In cell B1 enter the function: =TEXT(A1,"mmmm") In cell B1 the result is displayed: December With the 4 m's, the full name of the month is displayed

It also works to display only the day of a date

  1. In cell A1 enter a date: 12/6/2022

  2. In cell B1 enter the function: =TEXT(A1,"ddd") In cell B1 the result is displayed: Tue With the 3 d's, the summarized name or acronym of the day is displayed

Or also to display the full name of the day

  1. In cell A1 enter a date: 12/6/2022

  2. In cell B1 enter the function: =TEXT(A1,"dddd") In cell B1 the result is displayed: Tuesday With the 4d's, the full name of the day is displayed

Extract the year, month or day from a date


With the Text function, a date or a value is displayed with the format that we define, however in Excel we have functions to extract or remove something from a cell.


To extract specific text from a cell we can use the Extract function


But if we need to extract the components of a date which are: the year, the month and the day, we have the functions Year, Month and Day

Extract the month from a date


To extract the month from a date, use the =Month(Cell) function: In cell B1 enter =month(A1) and this is the result. 12 (numeric month)


Extract the day from a date


You can use the =day(A2) function to extract only the day: 6 (numerical day)


Extract the year from a date


Use the function =year(A3) to extract only the year: 2022


Uso de las funciones día, mes y año para extraer datos con Microsoft Excel | Xyclos

Prepare in Data Analysis

In the Microsoft Excel Basic Intermediate Business course, you will learn in depth how to manage dates, how to manage times, how to perform calculations with dates and times, how to use text functions, how to use Filters to perform analysis; with excellent content that will leave you prepared to advance to the next level by taking the Microsoft Excel Intermediate Advanced Business course, after which you will be ready with all the knowledge to create Reports and Dashboards by taking the Power BI Interactive Business Analysis course, taking your business analysis data to the next level.


One of the objectives of this training is, of course, to prepare you for the use of artificial intelligences, which require solid knowledge to get the most out of them.


Do not wait more. Time is running out and it is better to prepare today. You will see the change.


OpenAI News - ChatGPT

A week ago (Nov 30, 2022), a new version of artificial intelligence called ChatBot GPT3 from the company OpenAI was published.


It's something fantastic, really impressive.


You can ask it any but any question and it responds in seconds and its access is free: https://chat.openai.com/auth/login


To use Artificial Intelligence (AI), humans must be well prepared to interact efficiently with it; so I recommend you take our excellent courses and be ready for this fascinating present we have.


Do not wait more. You will see how you progress with the knowledge we provide you in our Spanish training courses in Microsoft Excel, Power BI and the complementary use of AI's.
















106 views0 comments

Comments


bottom of page