A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
L |
M |
N |
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
Business
Days And Periods |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4 |
|
n Shows how the the fraction of year between
dates is affected by Period days falling on holidays |
5 |
|
n
Note that it
is the movement of the period dates alone that causes the change, the two
dates are not
moved in this example. |
6 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
7 |
|
|
|
|
|
BusDay |
|
Business Functions |
|
|
|
|
|
|
|
|
|
|
8 |
|
From Date |
To Date |
DayCount |
Periods |
Switch |
|
DiffY |
TpY |
Con |
LongHand |
|
|
|
|
|
|
|
|
|
9 |
|
29 Feb 04 |
31 Dec 04 |
6 |
+12 |
|
|
0.834 years |
0.834 years |
0.834 years |
0.834 years |
|
|
|
|
|
|
|
|
|
10 |
|
29 Feb 04 |
31 Dec 04 |
6 |
-12 |
|
|
0.834 years |
0.834 years |
0.834 years |
0.834 years |
|
|
|
|
|
|
|
|
|
11 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
12 |
|
29 Feb 04 |
31 Dec 04 |
6 |
+12 |
20 |
|
0.829 years |
0.829 years |
0.829 years |
0.829 years |
Weekend extends last period 2 days. First
period unnaffected. |
|
|
|
13 |
|
29 Feb 04 |
31 Dec 04 |
6 |
-12 |
20 |
|
0.829 years |
0.829 years |
0.829 years |
0.829 years |
Weekend extends last period 2 days. First
period unnaffected. |
|
|
|
14 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
15 |
|
29 Feb 04 |
31 Dec 04 |
6 |
+12 |
100 |
|
0.827 years |
0.827 years |
0.827 years |
0.827 years |
Weekend and New Year extends last period 3
days. First period unnaffected. |
|
16 |
|
29 Feb 04 |
31 Dec 04 |
6 |
-12 |
100 |
|
0.827 years |
0.827 years |
0.827 years |
0.827 years |
Weekend and New Year extends last period 3
days. First period unnaffected. |
|
17 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
18 |
|
29 Feb 04 |
31 Dec 04 |
6 |
+12 |
200 |
|
0.829 years |
0.829 years |
0.829 years |
0.829 years |
Weekend extends last period 2 days. First
period unnaffected. |
|
|
|
19 |
|
29 Feb 04 |
31 Dec 04 |
6 |
-12 |
200 |
|
0.829 years |
0.829 years |
0.829 years |
0.829 years |
Weekend extends last period 2 days. First
period unnaffected. |
|
|
|
20 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
21 |
|
BusDaySwitch |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
22 |
|
20 |
in advance, monthly (first day of month)
Plain Business Days: Weekends only excluded |
|
|
|
|
|
|
|
|
|
|
|
23 |
|
100 |
in advance, monthly (first day of month) UK
Business Days (National): UK National Bank Holidays and weekends excluded.
See List of Holidays |
|
|
|
|
|
|
|
24 |
|
200 |
in arrear, monthly (1 Jan payment of Dec
accrual, etc) USA Business Days: US New York Stock Exchange Holidays and
weekends excluded |
|
|
|
|
|
|
|
|
25 |
|
DayCount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
26 |
|
6 |
Actual/Actual
(Within Period). |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
27 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
28 |
|
BusDaySwitch |
|
|
20 |
|
|
100 |
|
|
200 |
|
|
|
|
|
|
|
|
|
29 |
|
1
Feb 04 |
Sunday |
|
Weekend |
|
|
Weekend |
|
|
Weekend |
|
|
|
|
|
|
|
|
|
30 |
|
2 Feb 04 |
Monday |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
31 |
|
29 Feb 04 |
Sunday |
|
Weekend |
|
|
Weekend |
|
|
Weekend |
|
|
|
|
|
|
|
|
|
32 |
|
1
Mar 04 |
Monday |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
33 |
|
1 Apr 04 |
Thursday |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
34 |
|
1 May 04 |
Saturday |
|
Weekend |
|
|
Weekend |
|
|
Weekend |
|
|
|
|
|
|
|
|
|
35 |
|
2 May 04 |
Sunday |
|
Weekend |
|
|
Weekend |
|
|
Weekend |
|
|
|
|
|
|
|
|
|
36 |
|
3 May 04 |
Monday |
|
|
|
|
May Day (UK National) |
|
|
|
|
|
|
|
|
|
|
|
|
37 |
|
4 May 04 |
Tuesday |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
38 |
|
1 Jun 04 |
Tuesday |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
39 |
|
1 Jul 04 |
Thursday |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
40 |
|
1 Aug 04 |
Sunday |
|
Weekend |
|
|
Weekend |
|
|
Weekend |
|
|
|
|
|
|
|
|
|
41 |
|
2 Aug 04 |
Monday |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
42 |
|
1 Sep 04 |
Wednesday |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
43 |
|
1 Oct 04 |
Friday |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
44 |
|
1 Nov 04 |
Monday |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
45 |
|
1 Dec 04 |
Wednesday |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
46 |
|
31 Dec 04 |
Friday |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
47 |
|
1 Jan 05 |
Saturday |
|
Weekend |
|
|
Weekend |
|
|
Weekend |
|
|
|
|
|
|
|
|
|
48 |
|
2 Jan 05 |
Sunday |
|
Weekend |
|
|
Weekend |
|
|
Weekend |
|
|
|
|
|
|
|
|
|
49 |
|
3 Jan 05 |
Monday |
|
|
|
|
New Years Day (UK National) |
|
|
|
|
|
|
|
|
|
|
|
|
50 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
51 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
52 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
53 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
54 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
55 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
56 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
57 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
58 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
59 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
60 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
61 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
62 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
63 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
64 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
65 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
66 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
67 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
68 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
69 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
70 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
71 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
72 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
73 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
74 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
75 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
76 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
77 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
78 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
79 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
80 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|