• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

DATEVALUE

This function converts a text string into a valid date (in other words, a date serial number). The text string must contain data that is recognizable as a date. The function recognizes text entered in any of the date formats shown in the Number tab in the Format Cells dialog box, when you choose the Date category. You can specify any date from January 1, 1900 to February 6, 2040. The format of a DATEVALUE function is

=DATEVALUE(text)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint