DATE function

Description

Serial date number to string function. DATE(dnr) returns the date corresponding with the serial date number dnr, expressed as a string.

Example

DATE(DATEVALUE(A1)+7) equals "09.06.1996" when cell A1 contains the date string “8.30.96” (date format MM.DD.YY)

Calculator

Related functions

• TIMEVALUE function
• List of Date and time functions