Excel Function : DATE
Category
Date and time
Description
Returns the serial number of a particular date
Microsoft Excel Reference Page
https://support.office.com/en-us/article/DATE-function-e36c0c8c-4104-49da-ab83-82328b832349
Syntax and Description of the DATE Excel Function
=DATE(year,month,day)
About DATE Excel Function
The DATE function in Excel returns the current system date as a serial number. This function is useful for inserting the current date into a cell or formula. The DATE function is a built-in function in Excel that is categorized as a Date/Time Function. It can be used as a worksheet function (WS) and a VBA function (VBA) in Excel.