Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
1
00:00:00,980 --> 00:00:04,460
In this video we will solve the date and time formula.
2
00:00:04,460 --> 00:00:12,490
Case study will first calculate the number of working days in quarter 1 will use network based or die
3
00:00:12,510 --> 00:00:20,310
A.L. function to calculate the number of working days the network based on the A.L. function gives us
4
00:00:20,310 --> 00:00:24,170
the flexibility to attain the weekend days in a V.
5
00:00:25,400 --> 00:00:33,210
The standard network base function assumes that both Saturday and Sunday are weekends and it comes only
6
00:00:33,210 --> 00:00:36,120
Monday to Friday as working days.
7
00:00:36,210 --> 00:00:39,720
So let's say be 27 on the formula that
8
00:00:42,550 --> 00:00:52,240
contain and from the list of formulas select network based dot I ended Excel displays that function
9
00:00:52,240 --> 00:00:56,700
arguments dialog box clicking I started
10
00:00:59,640 --> 00:01:07,590
and select B2 which has a start date for Carter 1
11
00:01:10,980 --> 00:01:16,910
click aside and it and select C2 which has ended for quarter 1
12
00:01:19,880 --> 00:01:30,900
the third parameter weaken is a number that specifies when the weekend occurs and we can store only
13
00:01:30,990 --> 00:01:42,600
seven days out of Saturdays are working this the number that we use here is 11 eleven indicates to excel
14
00:01:43,200 --> 00:01:47,840
that we only want to use Sunday as we can.
15
00:01:48,210 --> 00:01:55,740
If you want to see the full list of numbers that can be used please dear friends the self reading material
16
00:01:55,800 --> 00:01:58,790
or the reading of documents available in the course.
17
00:01:58,860 --> 00:02:09,860
Finally we need to tell this function about holidays on the list of holidays worksheet seller cell B2
18
00:02:10,650 --> 00:02:19,600
which has the holiday information since quarter 1 has only one holiday will select only some B to click
19
00:02:19,630 --> 00:02:20,110
Okay.
20
00:02:21,240 --> 00:02:27,770
You can now see that celebrate 27 on monthly sales worksheet displays the number of working days in
21
00:02:27,770 --> 00:02:34,090
quarter 1 let us do this exercise for the remaining 3 quarters.
22
00:02:34,090 --> 00:02:39,240
We now have the month working days for all four quarters.
23
00:02:39,310 --> 00:02:42,850
Let us know calculate sales per day for quarter 1.
24
00:02:43,060 --> 00:02:50,530
To do that you will divide the net sales for quarter one that we had already calculated by the number
25
00:02:50,530 --> 00:03:04,030
of working days let us do that select Cell C 27 on monthly sales worksheet and type it called all select
26
00:03:05,380 --> 00:03:17,090
cell D 20 which has net sales for quarter 1 divided by cell B 27 which has a number of working days
27
00:03:17,390 --> 00:03:28,500
in quarter 1 press enter and we now have sales per day for quarter 1 Let us repeat this for the remaining
28
00:03:28,500 --> 00:03:30,300
three quarters.
29
00:03:30,300 --> 00:03:35,110
We now have sales per day for all the four quarters.
30
00:03:35,110 --> 00:03:44,420
As you can see quarter 3 had the highest sales per day followed by quarter 4 and quarter on quarter
31
00:03:44,420 --> 00:03:46,490
2 had the lowest sales per day.
3414
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.