Excel Function : DATE

Download now!

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.