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

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