PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
DATE function comes under the DATE FUNCTIONS category in GOOGLE SHEETS.
DATE FUNCTION simply converts a given YEAR, MONTH and DATE into DATE .
THIS PARTICULAR FUNCTION IS USED IN MAXIMUM FINANCIAL FUNCTIONS TO ENTER THE DATE.
DATE FUNCTION converts the given year, month and date into DATE in Google Sheets.
THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.
The Syntax for the function is
=DATE(YEAR, MONTH, DATE)
THE DATES SHOULD BE PUT USING THE DATE FUNCTION
=DATE(YYYY,MM,DD) OTHERWISE IT’LL RETURN AN ERROR.
YEAR | MONTH | DATE |
2020 | 11 | 20 |
2020 | 14 | 21 |
1899 | 1 | 1 |
2020.2 | 1.5 | 2.6 |
2020 | 1 | 1 |
THE DATE FUNCTION WILL ADD THE ADDITIONAL MONTHS OR DAYS [ OVER THE VALID LIMIT OF MONTHS OR DAYS ] TO THE DATE AND EVALUATE THE RESULT.
In the light of above fact, we can see that the DATE FUNCTION simply added the 2 over the limit months to the date and gave the result which is 2/21/2021.
Same is with the case of DATE which we’ll see in the further examples.
EXAMPLE 3:
The dates in the GOOGLE SHEETS are represented a numeral which is the count of the days from the 1.1.1900.
If any date prior to the standard initial date is given, it gives the result by adding 1900 years to this.
In this example the year, month and day are 1899, 1 and 1. The result is simply by adding 1900 years i.e. 1.1.3799
EXAMPLE 4:
The value of year , month and day are 2020.2 , 1.5 and 2.6
The result in this case is 1/2/2020 which means that date function removed all the decimal part and kept the whole number only and calculated the date.
EXAMPLE 5:
It has the value of year, month and day as 2020, 1 and 1.
It simply shows that we can also enter the date by passing the values directly into the function.
For example, the date has been entered as =DATE (2020,1,1).
DATE function works in a very flexible manner. It acts as a sequential number and we have many wrong formats which will result in some solution
such as
=DATE(2020,02,30)
This date won’t generate any error for there are no 30 days in Feb but it’ll show this date as 1st MARCH 2020.
Similarly the following translations are there
=DATE(2020,13,01)
will be treated as
1st JAN 2021 as there are no 13 months in an year but it’ll create one year of the twelve months and start the next month and year.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE