Hello everyone and welcome to a new
Ebm computer tutorial today
Lesson 21 Course Excel 2016
from scratch well today we will make
first chapter of the functions
date say there are different
Date functions that are going to
allow play date as extracting
parts of dates SEARCH few
days between two dates, there are a few
While we will start the first
example we will do is this I
I have here a column with dates and 27, 28
29, 30, 31 and 1 have all evidently
one box but I
interested in having here the day
here the month and year here then for
That'll use three functions that are
very easy to use and so I'll have
each thing separately or I'm going to
meter by fx and I will look here
date and time functions, and will
start by putting on the
is very
easy because we will simply mark
box date that would A2 and
It is done
then it has already extracted me hence the
the twenty-seventh day number itself
appears threw down the rest
Now let's practically a month for
the same date
hour and I will look for a function that
I called to accept and month
He marked the date pulled down and there
I have the 4th and last as
five more because I will finally
take as fx year and have here
year
the same frame and pulled to date
down and then she would
broken down both day a month as
2017, we will
add one more thing this tutorial
Let's assume I have two here
dates
one is today and another is that of
beginning of the year and I'm interested
see how many days there are between these two
dates for which are the days that
we pay a person for the
days worked
there are some
options but we will see now the option
faster
I get here and score an equal and now
just what I'll do is subtract
the first date less
the second I give to enter and already
115 days would,
then we see that there are some
functions in which we can remove it
the days are public holidays,
weekends but here without
plus it gives us the forgiveness dates
days between those two dates very
While it is here tutorial
today if they liked they can give me a
like you can subscribe to my channel and
They know where you put down there
Subscribe and so they will be
informed of the video or videos that we got
every day I can follow in the social networks and
on the websites of Ebm computer
Garret and I also bm
would like to share these videos
with friends and acquaintances through
social networks
and knowledge will reach
more people, any comments or
suggestion or request they put me
below in the description of the video, very
well thank you very much and even video
morning
For more infomation >> "Energía de J Balvin recibe dos premios | Billboards | Entretenimiento - Duration: 3:47. 
For more infomation >> J Balvin interrumpió la entrevista de Zion y Lennox | Billboards | Entretenimiento - Duration: 1:04. 
For more infomation >> Opel Astra 1.6 CDTI EDITION Model K - Duration: 1:03. 
No comments:
Post a Comment