DATEVALUE Function in Excel

Home/Excel Formulas/DATEVALUE Function in Excel

What is the use of DateValue function?

Converts a date represented by text to a serial number for a date.
Note: To view the serial number as a date following are the steps.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


a. Select the cell(which contains serial number)
b. Goto Home tab
c. Goto Number Group
d. Go To Number tab.
e. Select date from the category
f. Select the date format from the Type and then Click Ok.

What is the syntax of DateValue function?

DATEVALUE Function in Excel - syntax

DATEVALUE(date_text)

Where date_text: is text that represents a date.

DATEVALUE Function in Excel – Examples

DATEVALUE Function in Excel - Examples

Reference:

Please refer the below article for more Date & Time Excel functions.
Date & Time Excel Formulas

Please refer the below article for more Excel Functions.
Excel Formulas | Home

 
 
Related Resource External VBA Reference
Excel VBA Reference Project Management Reference
VBA Reference:
Excel Reference:
By |May 15th, 2013|Excel Formulas|0 Comments

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

Leave A Comment


Related pages


what is concatenation in excelexcel event calendar templateexcel vba counta functionvlookup hlookup pivot table tutorialhow to insert box in excelhow to delete blank rows in excel 2010excel 2007 vlookup tutoriallength of array vbaexcel 2003 macrosmicrosoft word add developer tab to ribboncreating charts in excelnamed ranges vbainsert button vbaexcel macro free workbookmicros and macros in exceluse of vlookup in excel 2010combo box vba excelhow to create a pivot table in excel 2003create userform in excel vba using codemacro security excel 2010example of macros in excelproject dashboards templatesvlookup definitionexcel vba hide columnsvbscript nested ifmicrosoft excel 2010 tutorial pivot tablesmastering excel formulasformula to remove duplicates in excelvba array tutorialvlookup for dummies 2010learning vba in excelexcel tutorial intermediateexcel vba rename filecreate table access vbaconvert excel to csvvba collection excelcopy range vbaproc sql tutorialsorting vbaexcel object model referenceclear cell vbaproject dashboard in excelexcel vba datevaluesteps to create dashboard in excel 2007how to unhide columnsproject management templates in excelvba dir commandexcel looking for duplicateshow to unlock excel passwordexcel vba msgbox new lineconverting xls to xmlsort highest to lowest excelvba filtersexcel dashboards and reports 2010frequently asked interview questions for freshershow to unmerge cells in wordpublic variables vbaexcel dynamic cell referenceunlocking excel sheetexcel with macrosexcel activeworkbook.saveasfree excel calendar 2014ado odbcvba function excelmaster sheet excelprotect worksheet excelmacro tutorial in excelwhat is dml and ddl in sql serverexcel vba range formulaexcel formula for alphabetical orderpassword protect multiple excel filesvlookup usageagenda template excelunhide excel column