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

DATE()

Related functions

This site uses cookies to store information on your computer. More info...