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


vlookup formula with examplecountif function excel 2013pivot table refresh vbaexcel delete duplicateslogical operations in excelpivot tables excel tutorialhow do you hyperlink in excelvbscript message box numbered list and valueshow to apply sumif formula in excelexcel vba borderssumif function in excel 2007vba word textboxexcel change rows to columnsvba column rangesas isnumericexcel macro sampleexcel vba select columnsexcel vba sample projectsvba casesvba tricksvba create filemicrosoft excel 2010 tutorial pivot tablesexcel vba rangesql dcl commandsmicrosoft excel 2010 tutorial pivot tablescell in vbashortcut for format cellsvba declaremicrosoft excel 2010 test questions and answersdrop down list excel 2007vba excel copyvba oracle connection stringexcel formulas vlookupexcel unshare workbooknew adodb.connectionhide unhide excelhow to learn formulas in excelexcel cell background colorhow to expand rows in excelfor loop vba excelvlookup formula in excel 2010 with exampleconcatenate formula in excelexcel vba import csvexcel.application.workbooks.openvba clear selected cellsvba application waithyperlink examplesproject planning freewarehow to remove a drop down box in excelcopy paste macroshortcut to insert column in excelexcel formula functions and examplesexcel pie chart titlehow to delete duplicates in excelexcel array vbahow to stop vba code runningdelete blank rows vbavba integer to stringprotect worksheet in excelexcel how to insert rowhow to use pivot table in excel 2010excel 2010 vlookup examplevba status bar progresshlookup formula with examplemacro excel programmingadvance excel tipsvba create new workbookexcel macro basicsunprotecting excel sheetvba worksheets rangevba macro outlookhow to unhide a tab in excel 2010c programming viva questions and answers pdfdelete blank rows exceladvanced vba tutorialsql update from excelvba write text filevlookup for dummies tutorial