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.
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
YOU MAY LIKE