Syntax:
=DATEVALUE (date_text)
This displays a serial number that represents a particular date in Excel. It converts a date in text format to a valid date.
Arguments:
date_text - A valid date in text format.
Usage notes:
If date_text is a cell address, the value of the cell must be text. If date_text is entered directly into the formula it must be enclosed in quotes.
Will return a #VALUE error if date_text refers to a cell that does not contain a date formatted as text.
=DATEVALUE (date_text)
This displays a serial number that represents a particular date in Excel. It converts a date in text format to a valid date.
Arguments:
date_text - A valid date in text format.
Usage notes:
If date_text is a cell address, the value of the cell must be text. If date_text is entered directly into the formula it must be enclosed in quotes.
Will return a #VALUE error if date_text refers to a cell that does not contain a date formatted as text.
No comments:
Post a Comment
Thank You.
https://linwintech.blogspot.com/