PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

HOW TO DISPLAY THE CURRENT MONTH AND CURRENT DAY IN WORDS IN EXCEL

INTRODUCTION

DATES and TIME , if you are new to Excel and you have already tried using those format, 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 which 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.CLICK HERE TO VISIT.

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 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”)

 

 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”)
HOW TO FIND CURRENT DATE AND MONTH IN WORDS
STEPS TO FIND CURRENT DAY AND MONTH IN WORDS

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.

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]

Like this:

Like Loading...

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW
%d bloggers like this: