Microsoft Excel “DATEVALUE” is the very useful where dates are available as TEXT and need to convert them to proper DATE format. DATEVALUE function helps to convert the dates to proper DATE format to make the database useful.
DATEVALUE function is very easy to apply since there is only one argument in the function. DATEVALUE function may returns the output in number format and you may need to change the format of the cells to “DATE”. We will discuss the steps of how to convert the Text Dates into Date format and change the cells format.
“DATEVALUE” can be used in various databases and really helped where database is imported from the other sources. Generally, where database is imported from other sources i.e. csv, text etc. data is converted in TEXT.
DATEVALUE function really helps in the above case and imported Text Dates can be converted in proper Date format in very easy way. Converting Date manually (one by one) to change the Date format is very difficult and
“DATEVALUE function” helps to apply the function in large database at once and makes the work easy, saves time and increases efficiency.
“DATEVALUE” is very useful and can be used in many situations. Like it can be used as follows:
– Imported databases, where details are in Text format and Date is to be converted in proper Date Format.
– Where transformation of existing database is required, need to prepare summary at Date level
– Or any other database where there is requirement changing date format then “DATEVALUE function” can be used
–“DATEVALUE” returns to value in correct date format. If function did not find the date in Text format then it will give an error i.e. #VALUE!.
-Output of the DATEVALUE function may appear in Number format i.e. 18th March 2020 as 43908, in this case cell format should be changed to Date Format.
=DATEVALUE(date_text)
date_text, argument is used to give the cell reference. It is the cell number that is to be converted to proper Date Format
Suppose we have one database where Date is appearing in various Text Format and we need to convert them to proper Date format. We will follow as below:
We can evaluate the output that Dates in various text formats in the database can easily be converted in proper Date Format.
As we discussed, Output of the DATEVALUE function may appear in Number format i.e. 18th March 2020 as 43908, in this case cell format should be changed to Date Format. Follow below steps to convert the format.
Hope you liked. Happy Learning.
Don’t forget to leave your valuable comments!
VBA code that will sum cells by its color through excel function. This code will really help in making the analysis and presentation better.
COLUMN function is used to get the column reference number of the excel worksheet. COLUMN Function has only one argument.
“NETWORKDAYS” function is very helpful feature in the Microsoft excel to calculate the working days from a particular period excluding “Saturday and Sundays”. NETWORKDAYS function subtract the Start Day from the End Date provided.
INDEX function is used to get the value from a cell range or table, function returns the value from a table where row and column intersect with each other.
TEXT function is used to change the formatting or appearances of the text. There are various types of formatting available.
COUNTA function is used to get the total count of Any-value or Non-Blanks in range. COUNTA Function has one required and optional argument: value1, value2