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

LIMITED TIME OFFER
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


project milestone template pptexcel vba selectvba msgbox vbcriticalrun sql in vbahighlight a column in excelvba array of stringsexcel dashboard widgetsvba join arrayexcel 2007 vba tutorialexcel vba testvba excel save workbookexcel shortcut sheetexcel vba activatevba while loopsexcel macro clear sheetexcel vba loopsarray macro excelsql select excelmicrosoft templates project managementhow to enable developer in excelexcel vba select rangevb inputboxselect cell vbahse meeting minutes templatemacro to close excel fileexcel gotoadodb recordset methodsvba copy from another workbookhow to create excel macrosexcel countif formula examplesendmail syntax examplecalculating force worksheetformulas in vbaworksheet in excel definitionlast cell in excelhow to use excel lookup functionvba duplicate sheethow to insert a row in excelvba print functionvb scripting interview questions and answers pdfvlookup explanationsql aptitude questions with answers pdfchanging rows to columns in excellen function in excelthissheet vbausing averageif in excelexcel unhide workbookvlookup excel 2007 tutorialhow to use hlookup in excel with exampleshortcut key strikethrough excelexcel joining cellsdonut chart generatorconcatenate formula in excelhow to copy and paste excel sheetwhat is excel ribbonproject spreadsheet template excelactivecell in vbapivots excelvba reference worksheetexcel kpi dashboard templatesunhide excel columnsunlock macro passwordvba option base 1excel functions vbaexcel macro range variablevba find last rowexcel vba write to text fileexcel vba select columnscombobox in excelexcel hide tabsunshare a shared workbookexcel change columns to rows