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