# 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.

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

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.