Hello everyone and welcome to a new
Ebm computer tutorial lesson today
22 Course Excel 2016
from scratch While we will continue
the date and time functions and that
Let's see is this is a
NETWORKDAYS function called him
good thing about this feature is that we
You will say the days between two
but dates will obviate the end of
week and also if we give a list
the parties are in that community in that
country so as we will say
exactly working days
We will work or days there
between two parties but if they are
weekdays well then I'm going to
by fx here and I'm going to
the date and time functions and here
I NETWORKDAYS
then tells me start date date
Initial doing puts us your number
dates represents the initial date
in because I give this to the first
and deliver serial date 01/01/2017
end date which I have above
31/12/2017 and
directly to me it puts me you are 260
working days but I'm going to
add parties
This list simply marked me here
He pulled down and enters it from
new parties makes you as
are already out there me 249 days
working between this function is very
either because it avoids directly
weekends and takes away the days
either party are seen as a
function is very easy to do and
We will add more than two functions
They are the volatile type
because they are volatile why not
need any argument
Let's assume that we want
I use a function to date and
today that we choose for
Here we will see
here today then we automatically
returns today's date in the
we would have no more problems it
only that it is changing and tomorrow
You could then tomorrow's date
that we could serve a
template would then etc.
another called now is exactly
but also it puts us equal time
there we have 04.30.2017 14:40
well here today's tutorial
with the second part of the functions
date and time, if you liked me
They can give like can subscribe to
my channel already know where you put down there
Subscribe and will be informed
video or videos that go up to
Daily you can follow me on networks
social and pages of Ebm
Garret computer and any Ebm
comments or suggestions or requests me
I put it under answering areas
very well thank you very much and even video
in the morning
Không có nhận xét nào:
Đăng nhận xét