Excel Function : DATEVALUE

Download now!

Excel Function : DATEVALUE

Category

Date and time

Description

Converts a date in the form of text to a serial number

Microsoft Excel Reference Page

https://support.office.com/en-us/article/DATEVALUE-function-df8b07d4-7761-4a93-bc33-b7471bbff252

Syntax and Description of the DATEVALUE Excel Function

The syntax for the DATEVALUE function in Microsoft Excel is: DATEVALUE( date_text ) date_text is a text representation of a date.

About DATEVALUE Excel Function

The DATEVALUE function in Excel converts a date that is stored as text into a date that is recognized by Excel as a date. This is useful if you have a date stored in a text format that you want to use in a calculation.