Date Formula creates a text date out of numeric date. Use DATE formula in Excel when you need to take three separate values and combine them to form a date.
The DATE formula in Excel returns the sequential serial number that represents a particular date.
Syntax of DATE formula in Excel : DATE(year,month,day)
The training excel file shown in the video is available for free download at http://www.myelesson.org 10 Most Used Formulas MS Excel