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.
Microsoft Excel “ISBLANK Function” is a Logical Function and it is used to check if cell in question is “BLANK OR NON-BLANK”. “ISBLANK Function” is used as a test to validate if cell contains any…
TRIM function is used to remove the additional spaces (i.e. spaces before/after/between the words) except for single space between words.
How to Find Duplicate Files In excel using VBA? Yesterday I was working on my computer and cleaning the drives to make some more space. I was surprised to see so many files saved at…
Calculations With Date In Excel Dates function also be used to subtract the Year, Month and Days from the existing dates. Sometimes we need to subtract specific period from the date. In case you are…
How to Insert Symbol in Excel? I came across many queries regarding inserting special symbols in Excel. Here we are guiding how you may do this quickly in excel. Follow these steps and you may…