Tuesday, November 5

Tag: excel help DATEVALUE Function

DATEVALUE Function To Convert Text Into Date

DATEVALUE Function To Convert Text Into Date

Date And Time, FORMULAS
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...