DATEVALUE

No Comments

 “DATEVALUE”

Used for – “DATEVALUE” function in MS Excel is used to find or convert a date into a serial number that MS Excel recognizes as a date.
Syntax – DATEVALUE(date_text)

             date_text – It is any date/reference cell that contains date, you typed or calculated which you want to convert a number. It is a compulsory field and if you did not fill any value excel will not proceed further.
                       
Example – Following example will clear the DATEVALUE function:-

In below table column A contains some dates in different formats and column G contains the DATEVALUE function.

A
B
C
D
E
F
G
1







2
=DATEVALUE("01/01/2018")






3
=DATEVALUE("01-JAN-2018")






4
=DATEVALUE("01-JAN")






5
=DATEVALUE("2018/01/01")






6
=DATEVALUE(B6&"/"&C6&"/"&D6)
1
1
2018



7








And result you get as under:-

A
B
C
D
E
F
G
H
I
1









2
43101








3
43101








4
42736








5
43101








6
43101
1
1
2018





7










NOTE :- Please do care of following points when you use DATEVALUE :-
  • Date_text must be entered in double quotation i.e. “”. otherwise it will give #VALUE! error.
  • Do not mark any cell whose value is already in date format it will return #VALUE! error.
  • When we used only date and month system will consider current year based on the system date. See result of A4 cell. It consider the year 2017 as the system year is 2017.

Dear readers, after reading the Content please ask for advice and to provide constructive feedback Please Write Relevant Comment with Polite Language.Your comments inspired me to continue blogging. Your opinion much more valuable to me. Thank you.