Afrikaans
Akan
Albanian
Amharic
Arabic
Armenian
Azerbaijani
Basque
Belarusian
Bemba
Bengali
Bihari
Bosnian
Breton
Bulgarian
Cambodian
Catalan
Cebuano
Cherokee
Chichewa
Chinese (Simplified)
Chinese (Traditional)
Corsican
Croatian
Czech
Danish
Dutch
English
Esperanto
Estonian
Ewe
Faroese
Filipino
Finnish
Frisian
Ga
Galician
Georgian
German
Greek
Guarani
Gujarati
Haitian Creole
Hausa
Hawaiian
Hebrew
Hindi
Hmong
Hungarian
Icelandic
Igbo
Indonesian
Interlingua
Irish
Italian
Japanese
Javanese
Kannada
Kazakh
Kinyarwanda
Kirundi
Kongo
Korean
Krio (Sierra Leone)
Kurdish
Kurdish (Soranรฎ)
Kyrgyz
Laothian
Latin
Latvian
Lingala
Lithuanian
Lozi
Luganda
Luo
Luxembourgish
Macedonian
Malagasy
Malay
Malayalam
Maltese
Maori
Marathi
Mauritian Creole
Moldavian
Mongolian
Myanmar (Burmese)
Montenegrin
Nepali
Nigerian Pidgin
Northern Sotho
Norwegian
Norwegian (Nynorsk)
Occitan
Oriya
Oromo
Pashto
Persian
Polish
Portuguese (Brazil)
Portuguese (Portugal)
Punjabi
Quechua
Romanian
Romansh
Runyakitara
Russian
Samoan
Scots Gaelic
Serbian
Serbo-Croatian
Sesotho
Setswana
Seychellois Creole
Shona
Sindhi
Sinhalese
Slovak
Slovenian
Somali
Spanish
Spanish (Latin American)
Sundanese
Swahili
Swedish
Tajik
Tamil
Tatar
Telugu
Thai
Tigrinya
Tonga
Tshiluba
Tumbuka
Turkish
Turkmen
Twi
Uighur
Ukrainian
Urdu
Uzbek
Vietnamese
Welsh
Wolof
Xhosa
Yiddish
Yoruba
Zulu
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.
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.