PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
CONTENTS
EXCEL FUNCTIONS-DATEVALUE
INTRODUCTION
DATEVALUE function comes under the DATE AND TIME FUNCTIONS category in Excel.
DATEVALUE FUNCTION function converts a date in text into the sequential number counted from JAN 1 1900.
THIS PARTICULAR FUNCTION IS USED FOR ANY SITUATION WHERE WE NEED TO DO SOME CALCULATION USING THE SEQUENTIAL NUMBER OF THE DATE.
PURPOSE OF DATEVALUE FUNCTION IN EXCEL
DATEVALUE FUNCTION returns a sequential number for the given date in text.
PREREQUISITES TO LEARN DATEVALUE
THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.
- Basic understanding of how to use a formula or function.
- Basic understanding of rows and columns in Excel.
- Some information about the financial terms is an advantage for the use of such formulas.
- Of course, Excel software.
SYNTAX: DATEVALUE FUNCTION
The Syntax for the function is
=DATEVALUE(DATE IN TEXT)
DATE IN TEXT The date shown as a text e.g. 7 jan, 7 jan 1990, jan 7 etc. But always remember to put the date text in “”.
EXAMPLE:DATEVALUE IN EXCEL
DATA SAMPLE
We will take different examples for checking how the DATEVALUE function will work.
STEPS TO USE DATEVALUE FUNCTION
In the above mentioned example, we have used many textual formats of date
the concerned formula is
=DATEVALUE(“text value of date”)
In the last example, we have not specified the year, so the Excel took the current year for the same.
CONFUSION CLARIFICATIONS
DATEVALUE FUNCTION OPTIONS
OTHER WAYS TO REACH THIS ARTICLE
DATEVALUE FUNCTION, CONVERT DATE TO SEQUENTIAL NUMBER, TEXT DATE TO DATE FORMAT
YOU MAY LIKE
- EXCEL FUNCTION DATE
- HOW TO INSERT WORD ART, OBJECT AND SYMBOL
- EXCEL-FUNCTION-SUM
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.