Just in case you are interested, it can be done without the x, y and z columns:
AliGW on MS365 Beta Channel (Windows 11) 64 bit
|
B |
C |
D |
E |
F |
G |
H |
I |
J |
4 |
Employee Name |
DOB |
Hire Date |
Exit Date |
Hire |
Worked |
Exit |
Years |
Weeks |
5 |
Empl 001 |
30/09/1990 |
09/03/2009 |
13/08/2024 |
18.44 |
15.43 |
33.87 |
15 |
13 |
6 |
|
|
|
|
|
|
|
|
|
7 |
Empl 002 |
22/03/1974 |
04/01/2008 |
31/10/2024 |
33.78 |
16.83 |
50.61 |
16 |
20.5 |
8 |
|
|
|
|
|
|
|
|
|
9 |
Empl 003 |
18/04/1980 |
27/07/2020 |
31/12/2024 |
40.28 |
4.43 |
44.70 |
4 |
5.5 |
10 |
|
|
|
|
|
|
|
|
|
11 |
Empl 004 |
03/04/1969 |
25/06/2008 |
06/03/2025 |
39.23 |
16.70 |
55.93 |
16 |
23 |
12 |
|
|
|
|
|
|
|
|
|
13 |
Empl 008 |
21/07/1990 |
03/12/2012 |
30/11/2024 |
22.37 |
11.99 |
34.36 |
11 |
11 |
Bookmarks