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


how do you unhide in excelvba code in excelpivot table tutorial 2010excel unsharevba excel button propertiesvba switchconcatenate excel formulainterview questions on testing for freshersvba create pdfexcel developer tab 2007multiple if conditions in excelms excel vbaexcel count duplicates in columnproject budget template excellistbox in accesscontains vbaexcel 2007 vba programmingcreating an excel macroapplication worksheetfunction countahow to protect excel sheet 2007vba programming in excelexcel 2007 timeline templateformat column vbausing the sumif function in excelcombining sheets in excelnested if statements excelarrays vba excelexcel checkbox in cellauto fit excelmacro security exceldashboard charts in excelexcel vba open file and copy dataexcel vba current worksheethow to remove a hyperlink in excelms excel interview questions and answersapplication.goto vbacreateobject scripting filesystemobject vbahow to create a vlookup in excel 2010vba word examplesproject portfolio management template excelpaste in vbahow to amalgamate excel spreadsheetsvba forecolor codesvba multiselect listboxmerge selected cellsaccess vba color codesuseful excel formulasswot analysis template powerpointms excel password protectunhide sheets macrovba scripting filesystemobjectpassword protect excel 2007 workbookrs getrowstemplate checklist excelturn on autofilter excel 2010vba dialog boxvba open workbookhow to unprotect excel sheet 2007what is meant by vlookupwhat is hlookup and vlookupdelete row excelexcel remove duplicates from listdrop down tabs in excelvba excel bookmost useful formulas in excelexcel vba pasteremoving macros from exceluseful excel formulasmacro in excel tutorial pdfvba on error msgboxms excel remove duplicate rowsobjects in excel vbavlookup in macrooffset in excel macrovba save excel file