DAETVALUE Function or DATEVALUE Formula in Excel with example

DAETVALUE Function or DATEVALUE Formula in Excel with example

DATEVALUE

Converts a date from text to a number that represents date later it can be formatted in desired format to achieve final date. DATEVALUE function in Excel give power to convert any valid string containing date.

Syntax

=DATEVALUE(date_text)

  • date_text: refers to a string having valid date

Formula

Output

Format

Next >> DAYS Function in Excel with example

Leave a Reply

Your email address will not be published.