Each argument is provided as a number, and the result is aserial numberthat represents a valid Excel date.
Apply a datenumber formatto display the output from the DATE function as a date.
Note: tomove an existing dateforward or backward in time, see theEDATEandEOMONTH.
TheTODAY functionreturns the current date to theYEAR function.
The YEAR function extracts the year and returns the result to the DATE function as theyearargument.
Themonthanddayarguments are hard-coded as 1.
Note: the DATE function actually returns a serial number and not a formatted date.
In Excel’s date system,dates are serial numbers.
January 1, 1900, is number 1 and later dates are larger numbers.
To display date values in a human-readable date format, apply thenumber formatof your choice.
The TIME function is useful when you want to assemble a proper time inside another formula.
YEAR Function
The Excel YEAR function returns the year component of a date as a 4-digit number.
