Table of Contents
- INTRODUCTION
- DISPLAY THE CURRENT MONTH AND CURRENT DAY IN WORDS IN EXCEL
- STEPS TO DISPLAY CURRENT DAY AND CURRENT MONTH IN EXCEL
- FAQs
INTRODUCTION
DATES and TIME, if you are new to Excel and you have already tried using those formats, I am pretty sure that you must have felt panicky at some sort of time.
It is quite obvious because when we don’t know the exact working of any system or process, we try to use it just by hit and trial method. It works sometimes and sometimes not.
Here we are talking about Dates and Time in Excel. These are the tricky formats that we need frequently in our reports or charts.
Many times, we need to do operations on them. We need to put them in the conditions to trigger some event which makes it very important for us to learn the exact procedures to perform a task concerned with the dates and time.
In this article, we would learn different tricks and methods to handle and manipulate Dates and Time formats so that they don’t mess up with our reports.
In this article, we‘ll learn the trick to display the current month and current day in excel. BEFORE READING THIS ARTICLE, IT IS REQUESTED TO VISIT THE PART I WHICH DISCUSSES THE CONCEPT OF THE DATE AND TIME IN EXCEL FOR BETTER UNDERSTANDING.
THIS ARTICLE IS ABOUT INSERTING OR DISPLAYING THE CURRENT DAY AND CURRENT MONTH IN WORDS. FOR EXAMPLE, 17 MARCH (2022) WILL BE DISPLAYED AS THURSDAY FOR THE DAY, AND MARCH FOR THE MONTH. IF YOU WANT TO DISPLAY OR INSERT THE DAY AND MONTH IN NUMBERS, CLICK HERE.
DISPLAY THE CURRENT MONTH AND CURRENT DAY IN WORDS IN EXCEL
CONCEPT:
While creating the reports, we might need to display any DAY [ In words] and Month [In words].
Here are the simple steps to do the same.We‘ll make use of the TODAY() function which returns the current date in Excel. Use the function in the cell as
=TEXT(TODAY(),”DDDD”)
THE FORMAT DDDD is used for Day in words. Similarly, for the current month in words, we’ll use the following function.
=TEXT(TODAY(),”MMMM”)
TEXT FUNCTION IS A MUST TO LEARN IF YOU INTEND TO SHOW THE DATES OR TIME OR ANY OTHER DATA IN THE FORMAT OF YOUR CHOICE. CLICK HERE TO LEARN THE TEXT FUNCTION.
STEPS TO DISPLAY CURRENT DAY AND CURRENT MONTH IN EXCEL
- Select the cell where the current day is to be displayed.
- Enter the formula as
- =TEXT(TODAY(),”DDDD”)
- Now select the cell where current month name is to be displayed.
- Enter the formula as
- =TEXT(TODAY(),”MMMM”)
EXPLANATION:
In both of the solutions, we used the TEXT FUNCTION and TODAY FUNCTION.
TODAY FUNCTION returns the current date.
TEXT FUNCTION helps us to format the data as per requirement.
The format DDDD gives us the DAY IN WORDS and MMMM gives us the MONTH in words.
So, we apply the TEXT FUNCTION on the DATE for the format of the DAY IN WORDS and MONTH IN WORDS.
The results are as expected.
FAQs
HOW TO GET THE CURRENT MONTH ( IN WORDS) IN EXCEL?
Simply refer to the article above which shows the process to get the current month in Excel.
HOW TO GET THE CURRENT DAY AND MONTH ( IN WORDS) IN EXCEL WHICH UPDATES AUTOMATICALLY?
The ways discussed above to display or insert the day and month will give you a result that will update the result daily. It means it’ll always be correct because the outcome of the function will be refreshed every time you open the sheet.
DISPLAY THE CURRENT DAY UP TO 3 LETTERS ?
Use the function =TEXT(TODAY(),”DDD”). It’ll show the current day in words up to three letters.
For example,
mon for Monday
tue for Tuesday
and so on.
DISPLAY THE CURRENT MONTH IN THREE LETTERS?
Use the function =TEXT(TODAY(),”MMM”).
It’ll show the current month up to three letters.
For example,
Jan for January,
Feb for February
and so on.
WHAT IS THE FUNCTION TO GET TODAY’S DATE IN EXCEL?
TODAY() is the function to get current or today’s date in Excel. Simply use it as =TODAY() and it’ll display the complete day’s information.
To get the desired information, you need to use it with TEXT FUNCTION.
HOW TO KEEP THE DAY OR MONTH STATIC IN EXCEL?
You can insert the day or month manually and it’ll behave like a text and will be static.
or
You can use the above formulas, copy the result and paste it as a value.