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

Contents

HOW TO INSERT A DATE IN EXCEL TO AVOID PROBLEMS

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.
 
Most of the times , we directly type our dates and if , by chance, there is any problem in the format, the calculations always return an error and we need to again go back and check the formats of all the cell.
To avoid these problems, there must be a way, by which we can avoid all these problems.
So let us learn the way by which we can avoid any DATE FORMAT related problem. The solution is to use the proper DATE FUNCTION with the help of which we can create date from the text and use it anywhere without any problem.

 

BEST WAY TO INSERT A DATE IN EXCEL

If we want to be sure that we face no problems while working with the dates, here is the best way to enter the dates.

Always enter the date using the DATE FUNCTION which is very helpful in handling the dates and we never go wrong with this function.

The syntax of the function is

The Syntax for the function is

=DATE(YEAR, MONTH, DATE)

YEAR PUT THE YEAR IN YYYY FORMAT
MONTH PUT THE MONTH IN MM FORMAT
DATE PUT THE DATE IN DD FORMAT
 
Now, let us talk about its flexibility.
Even if we put any wrong month or date in this function , it still translates and rectifies the error.
For example.
By mistake we put the date of a JANUARY as 32 it’ll translate it to FEBRUARY 1 rather than giving an error.
Similarly if month goes to 13, it’ll be interpreted as First month of next year.
But yes, we need to always enter the correct date.
DATE FUNCTION HAS THE CAPABILITY TO CONVERT THE TEXT SNIPPETS INTO DATE. WE NEED TO PASS THE TEXT ARGUMENTS IN THE DATE FUNCTION AND IT BECOMES A DATE.
Let us take an example to verify this statement.
Let us put the three values of year, month and date in the cells having the TEXT FORMAT and pass these argument into DATE FUNCTION and check the output.
CREATE TEXT TO DATE IN EXCEL
CONVERSION OF TEXT TO DATE IN EXCEL

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

  • PICTURES ARE TOO SMALL?? Don’t worry, Click them, and pinch zoom to see them properly. All pictures are in high resolution.
  • KINDLY LIKE OUR FACEBOOK PAGE BY CLICKING HERE  AND IF WE NEED TO IMPROVE, KINDLY SEND US THE FEEDBACK ON [email protected]
  • Didn’t get what you were looking for?? Just put your question in the chat box present in the Right Lower corner. Name and email id [No spamming, just for the answer of your requirement] are needed.
*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW
%d bloggers like this: