Microsoft Excel Converting Date Data in Text Format to Date Format

This video demonstrates how text formatted dates are converted into date-formatted dates using certain functions such as mid, right and left and the date function

---

Closed Caption:

I'm going to take you through how to
convert dates in text format into date
there are multiple methods of converting
text format dates into date format this
is the first video from the series
conversion from text formatted dates to
do 4matic dates often times you receive
extra files or have to copy the date is
in text format which is not recognized
by Excel has cannot be used for any
calculation we could possibly be stuck
with some high-end time-consuming
solutions like riding macros or
downloading and learning add-ons
however there are some simple
easy-to-understand solutions to solve
this problem
imagine you have to convert multiple
rows of indy mmm yyyy format from string
to date this format can be converted to
date format using the formula and
certain text functions such as made
right and left the logic behind did
formalize that it returns the number
that your presence the date in XO
daytime code however this formula alone
is not sufficient for conversion as the
data is not incredible exle daytime
format so let's see how we can kind of
text format into a format good form left
fresh prompts the user to input ear then
month and finally d in order to identify
your right function needs to be used as
a specified number of characters from
rightmost point of a text string in this
case write function will extract 2010
from cell to which then is fed as here
in the dead formula
similarly met function is used to
extract month make function returns the
character from the middle of a text
string doing a starting position and
length in this case starting point is
the fourth character and we want to
extract two textures 0 and 1 the month
january left function is used to extract
days in this example 14 as you can see
this formula is broken down into three
parts your month and d the idea is to
extract each of these elements from rod
SL using text functions such as right
left and mid in a nutshell the formula
is a stated in cell b2 assuming that
that isn't la2 click enter ensure to
close bracket for the date function
simply double click on the plus sign and
here you have your date converted into
exile date & time code hope this was use
the swimming was brought to you by CS
learning academy / malaria initiative by
see axl math for any qualities you can
email us at learning at the axle mat.com
you