DATEVALUE Function To Convert Text Into Date
DEFINITION :- The Excel DATEVALUE Function Converts A Date Stored As Text In A Cell Into A Valid Excel Date. A Valid Excel Dates Are More Useful Than Text Dates As They Can Be Referenced And Can Be Used With Formulas And Pivot Tables To Perform Date-Based Reports Or Analysis.
Syntax:- =DATEVALUE(Valid Date As Text Format)
(1) If Date As Text Is Entered Directly Into The Formula It Must Be In Double Quotes . Or If Date As Text Is A Direct Cell Reference, Then The Value Of The Cell Must Be Stored As A Valid Date In Text Format.
(2) DATEVALUE Function Will Return A #Value Error If Date Stored As Text Of A Reference Cell That Does Not Contain A Valid Date In Text Format.
(3) If You Provide Only Two Value Like Date And Month, Then The DATEVALUE Function Will Auto Detect The Year...