ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Employee DataGeneral InformationVacation for 1st yearHOLIDAYSTOTAL
2
Namedate of receiptExperienceDays WorkedAs of the current date, vacation days earnedBilling PeriodDuration, Calendar DaysVacation PeriodTotal time off
3
7/14/2026StartEndStarthideEnd
4
1Isabella5/1/20188 year 2months 13 days 2 996 2515/1/20184/30/2019183/1/2023#VALUE!#VALUE!28
5
104/30/2023#VALUE!#VALUE!
6
2Oliver12/13/20187 year 7months 1 days 2 770 23212/13/201812/12/2019143/3/2023#VALUE!#VALUE!28
7
148/4/2023#VALUE!#VALUE!
8
3Lucas6/10/20188 year 1months 4 days 2 956 2476/10/20186/9/2019203/5/2023#VALUE!#VALUE!28
9
810/6/2023#VALUE!#VALUE!
10
4Charlotte9/16/20187 year 9months 28 days 2 858 2399/16/20189/15/2019213/7/2023#VALUE!#VALUE!21
11
#VALUE!
12
5Evelyn7/20/20187 year 11months 24 days 2 916 2447/20/20187/19/2019283/9/2023#VALUE!#VALUE!28
13
#VALUE!
14
15
16
https://exceltable.com/formula-example/
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
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
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100