DATE function comes under the DATE AND TIME FUNCTIONS category in Excel.
DATE FUNCTION simply returns the date as a sequential number of the day on that particular date counted form the first day on JAN 1 1900.
THIS PARTICULAR FUNCTION IS USED IN MAXIMUM FINANCIAL FUNCTIONS TO ENTER THE DATE.
PURPOSE OF DATE FUNCTION IN EXCEL
DATE FUNCTION returns a sequential number which represents a particular date counted from JAN 1 1900.
PREREQUISITES TO LEARN DATE
THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.
- Basic understanding of how to use a formula or function.
- Basic understanding of rows and columns in Excel.
- Some information about the financial terms is an advantage for the use of such formulas.
- Of course, Excel software.
SYNTAX: DATE FUNCTION
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.
EXAMPLE:DATE IN EXCEL
STEPS TO USE DATE FUNCTION
DATE FUNCTION OPTIONS
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
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
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
DATE FUNCTION, WHAT HAPPENS IF FORMAT IS WRONG IN DATE FORMAT, WHAT IS DATE FUNCTION, HOW TO USE DATE FUNCTION