All language subtitles for 4. Using the WORKDAY and WORKDAY.INT Functions

In this lesson, we're going to take a look at a couple of really quick little formulas that can be

useful.

And that is the work day function and the work days int function.

So let's start out with the work days function now in the table at the top here.

I have a list of tasks that need to be completed, and I also have the start date of those tasks.

So maybe this is some kind of basis for a project plan.

And in Column C, I've listed out the number of work days that each of these tasks is going to take.

Now, when I say work days, I mean Monday to Friday, so excluding the weekends I want I want to work

out is the finish date based on the work days and the start date.

So the work day's formula will basically calculate five days after the start date, but it won't include

any weekends in that calculation.

So let's go to finish date.

We're going to type in equals and we're going to use the work day function.

Now we have three arguments here start date days, and then we have an optional argument of holidays

because what you can also doing here is get the formula to exclude holiday days as well, so those won't

be public holidays, Christmas Day, New Year's Day, Easter Monday, things like that.

Now, in order to include the holidays, you need to have the holidays listed out somewhere so you can

see that I have all of the holidays in the UK listed out in a little table.

So the first argument here is the start date.

So I have that listed in cell before comma days.

So how many days is this task going to take?

Well, this task is going to take five days.

Now I could leave it just there.

I could close the bracket and hit enter.

And it's going to give me my finished day, excluding weekends.

However, if I wanted to include holidays as well, let's double click to edit comma.

I can then select the holiday dates.

So that is this that will range just here and say, and then I can copy this formula down and I have

my finished dates.

So that is how the work day's function works.

Now what about the work days int function?

Well, let's delete our AB finished date just here and take a look at work days int.

And it's this one just here.

Sorry, work day dot intel.

Let's double click.

Now this is pretty much the same, but it takes into account international weekends and holidays.

So the first argument is start date.

So before, that's nice and easy.

Number of days?

Well, that is five comma.

Now the third argument is weekend.

So if you have weekends that start on a different day, so maybe your weekend isn't Saturday and Sunday

in your location?

I know in the Middle East and other places.

Sunday and Monday tend to be the weekend.

You can account for that by selecting different days for your weekend.

So let's just do Sunday Monday for change.

And then if I want to add in holidays, I can do that as well.

So I might want to use these holiday dates again.

Close the bracket and enter, and then I can copy that formula down.

Once again, I'm going to get that little error because I'm not using all of the data, so let's to

ignore error.

So that's the difference between workdays and work days into.