Table of Contents
- PURPOSE OF DISPLAYING CURRENT DAY OR MONTH IN EXCEL
- DISPLAY THE CURRENT MONTH AND CURRENT DAY IN EXCEL
- WHAT IS THE FUNCTION TO GET TODAY’S DATE IN EXCEL?
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 the 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.
THIS ARTICLE IS ABOUT INSERTING OR DISPLAYING THE CURRENT DAY AND CURRENT MONTH IN NUMBERS. FOR EXAMPLE, 17 MARCH IS 03 FOR THE MONTH AND 17 FOR THE DAY. IF YOU WANT TO DISPLAY OR INSERT THE DAY AND MONTH IN WORDS, CLICK HERE.
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.
PURPOSE OF DISPLAYING CURRENT DAY OR MONTH IN EXCEL
The purpose is quite obvious.
We require the day or month in Excel frequently. We can enter the values manually but if we want it to be dynamic, we can make use of the functions.
DISPLAY THE CURRENT MONTH AND CURRENT DAY IN EXCEL
While creating the reports, we might need to display the current day or month in excel.
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
THE FORMAT DD is used for Day. Similarly, for the current month, we’ll use the following function.
REFERENCE: TEXT FUNCTION IN EXCEL
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
- Now select the cell where current month name is to be displayed.
- Enter the formula as
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 DD gives us the DAY and MM gives us the MONTH.
So, we apply the TEXT FUNCTION on the DATE for the format of the DAY and MONTH.
The results are as expected.
HOW TO GET THE CURRENT MONTH 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 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.
DISPLAY THE CURRENT DAY IN A SINGLE DIGIT?
Use the function =TEXT(TODAY(),”D”). It’ll show the day in single-digit but won’t show the days in single digit which are two-digit numbers e.g. 10 to 31.
DISPLAY THE CURRENT MONTH IN A SINGLE DIGIT?
Use the function =TEXT(TODAY(),”M”). It’ll show the month in single-digit but won’t show the month in single digits which are two-digit numbers e.g. 10 to 12.
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.
You can use the above formulas, copy the result and paste it as a value.