Tuesday, 12 September 2017

DATEVALUE Function

DATEVALUE Function


This function Converts a text string showing a date, to an integer that represents the date in Excel's date-time code.

Syntax: DATEVALUE(date_text)
Formula: =DATEVALUE("6/6/2012")
Result: 41066

No comments:

Post a Comment