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!
MAX function is used to get the largest number in range or list of values. MAX function has one required argument i.e. number1
SUMPRODUCT function performs multiplication of numbers within arrays and then sum the values SUMPRODUCT function has array1, 2.. arguments.
Table of Content Introduction Create a Detailed Work Allocation Template Define Case Types, Users and Status Configure Dropdowns in the Template Allocate Tasks Based on Skillsets Track Progress with Pivot Table Implement Conditional Formatting Regularly…
Excel Function SUBTOTAL Excel Function “Subtotal” is most commonly used formula in excel and it can make your work easy while performing simple mathematical calculations because of variety of features like: – You can use…
LARGE function is used to get the Largest k-th value from the range.
LARGE Function has two required arguments i.e. array, and k
Working with huge data is always exciting and challenging. From 2007 version onward, Excel is supporting more than a million rows in each worksheet. One of the common problems with huge data is “Duplicates” and the bigger problem is to identify and remove these duplicates. In this article, we will be sharing 4 ways to delete duplicate records from your data.