Converting dates with text functions


show more Converting dates with text functions provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Cleaning Up Your Excel 2010 Data show less
please wait ...

Converting dates with text functions

There are many different ways in which you can enter a date data into an Excel worksheet; however, a lot of different layouts don't lend themselves to working with Excel dates efficiently. To work with dates efficiently in Excel, they must be considered values, so that we can work with them computationally. Date, the way we see it in column A and in column C isn't really set up properly. But if we've got a ton of entries like this, we want to be able to convert them into actual dates, and usually this takes a separate column.

Now, a function you wouldn't necessarily know much about, but relatively easy to use, is a function called date, and this function needs a year, month and day. Now the date in Column A doesn't have any days associated with it, so we'll just use the first day of the month. So what can we do with this information? From the right-hand side of each of those entries there, the four rightmost characters consist of the year. So here's a function ...

Converting dates with text functions
Video duration: 6m 54s 1h 28m Appropriate for all

Viewers:

Converting dates with text functions provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Cleaning Up Your Excel 2010 Data

Subjects:
Business IT
Software:
Excel
Author:
please wait ...