Skip to main content
MedCalc
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
working
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