Show menu

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

Share on Facebook Share on Twitter

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