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.
Helpful links for the prerequisites mentioned above

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 “”.

 
 *This function will convert the date in text to sequential number but if the format of the cell is in DATE, it’ll convert the number to a date.
means
if we type =DATEVALUE(“8 JAN 2009) and the format of the cell is DATE,
the output will be 8-01-2009  in place of a sequential number.
 

EXAMPLE:DATEVALUE IN EXCEL

DATA SAMPLE

We will take different examples for checking how the DATEVALUE function will work.

 

 

 

EXCEL FUNCTION DATEVALUE ANIMATED EXAMPLE
EXCEL: FUNCTION DATEVALUE ANIMATED EXAMPLE

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

DATEVALUE function will simply convert the date in text to the sequential number.
If the format of the cell is already a DATE TYPE, the output will become a date instead of a sequential number.

OTHER WAYS TO REACH THIS ARTICLE

  • DATEVALUE FUNCTION, CONVERT DATE TO SEQUENTIAL NUMBER, TEXT DATE TO DATE FORMAT

YOU MAY LIKE

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

gyankosh060309@gmail.com

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: