Các hàm cơ bản trong excel

DANH SACH CAN BO - NHAN VIEN

NGAY XET: 1/5/2012
Le ThongMinh 43
Nguyen VanKinh
STT MANV HO TEN HO TEN MAHT MACV MADV MATD NGAY SINH NGAY CT TUOI THAM NIEN
1 HD042A Le Thong Minh Le Thong Minh HD 04 A 2 3/20/1969 3/4/1990 42.00 22.0
2 BC011A Nguyen Van Kinh Nguyen Van Kinh BC 01 A 1 9/30/1970 6/8/1992 41.00 20.0
3 BC021B Tran Trung Truc Tran Trung Truc BC 02 B 1 10/17/1972 8/6/1989 39.00 22.0
4 BC021A Luong Anh Hung Luong Anh Hung BC 02 A 1 10/29/1962 5/23/1985 49.00 27.0
5 HD032B Ly Le Hoa Ly Le Hoa HD 03 B 2 12/28/1955 4/30/1980 56.00 32.0
6 HD052A Vu Van Vien Vu Van Vien HD 05 A 2 2/19/1971 1/1/1994 40.00 18.0
7 BC023C Dao My Le Dao My Le BC 02 C 3 5/6/1963 4/24/1990 48.00 22.0
8 BC032B Ha Trung Hieu Ha Trung Hieu BC 03 B 2 12/31/1974 12/12/1988 37.00 23.0
9 BC043C Nguyen Van Ve Nguyen Van Ve BC 04 C 3 10/9/1956 5/5/1980 55.00 32.0
10 HD032C Le Thnh Tam Le Thnh Tam HD 03 C 2 8/14/1958 4/15/1979 53.00 33.0
11 HD042A Le Bon Ba Le Bon Ba HD 04 A 2 5/13/1967 10/22/1986 44.00 25.0
12 BC032E Le Thi Ly Le Thi Ly BC 03 E 2 10/19/1968 12/31/1987 43.00 24.0
13 HD023B Tran Van Cam Tran Van Cam HD 02 B 3 10/12/1972 12/23/1996 39.00 15.0
14 BC043C Ho Van Han Ho Van Han BC 04 C 3 2/26/1973 6/26/1991 38.00 21.0
15 HD033D Nguyen Ngoc Nga Nguyen Ngoc Nga HD 03 D 3 5/29/1977 6/19/1996 34.00 16.0
16 HD053E Tran Thi Lan Tran Thi Lan HD 05 E 3 3/14/1965 10/26/1983 46.00 28.0
17 BC033C Duong Van Chau Duong Van Chau BC 03 C 3 8/16/1974 11/27/1994 37.00 17.0
18 BC033B Ha Dinh Thang Ha Dinh Thang BC 03 B 3 12/19/1961 10/28/1986 50.00 25.0
19 BC043C Le Thanh Hung Le Thanh Hung BC 04 C 3 10/20/1961 10/28/1984 50.00 27.0
20 HD033E Nguyen Viet Tuan Nguyen Viet Tuan HD 03 E 3 3/20/1969 3/4/1987 42.00 25.0
21 HD032C Dao Thi Phung Dao Thi Phung HD 03 C 2 9/30/1970 6/8/1991 41.00 21.0
22 HD042A Tran Trung Duc Tran Trung Duc HD 04 A 2 10/17/1972 8/6/1994 39.00 17.0
23 BC032E Le Hong Son Le Hong Son BC 03 E 2 10/29/1970 5/23/1994 41.00 18.0
24 HD023B Le Huynh Duc Le Huynh Duc HD 02 B 3 12/28/1955 4/30/1978 56.00 34.0
25 BC043C Le Cong Minh Le Cong Minh BC 04 C 3 2/19/1971 1/1/1994 40.00 18.0
26 HD033D Nguyen Viet Phong Nguyen Viet Phong HD 03 D 3 5/6/1963 4/24/1990 48.00 22.0
27 HD053E Doa Thanh Bing Doa Thanh Bing HD 05 E 3 12/31/1974 12/12/1988 37.00 23.0
28 BC033C Duong Hong Khanh Duong Hong Khanh BC 03 C 3 10/9/1956 5/5/1982 55.00 30.0
29 BC033B Trinh Quoc Hung Trinh Quoc Hung BC 03 B 3 8/14/1958 4/15/1980 53.00 32.0
30 BC043C Nguyen Van Cuong Nguyen Van Cuong BC 04 C 3 5/13/1967 10/22/1989 44.00 22.0
31 HD033E Tran Thanh Tam Tran Thanh Tam HD 03 E 3 10/19/1968 12/31/1987 43.00 24.0
32 HD032C Dinh Cong Bua Dinh Cong Bua HD 03 C 2 10/12/1972 12/23/1996 39.00 15.0
33 HD042A Dinh Viet Tuong Dinh Viet Tuong HD 04 A 2 2/26/1973 6/26/1991 38.00 21.0
34 BC032E Nguyen Thi Hue Nhung Nguyen Thi Hue Nhung BC 03 E 2 5/29/1977 6/19/1994 34.00 18.0
35 HD023B Doan Cao Vu Doan Cao Vu HD 02 B 3 3/14/1965 10/26/1983 46.00 28.0
36 BC043C Le Phong Vu Le Phong Vu BC 04 C 3 8/16/1974 11/27/1994 37.00 17.0
37 HD033D Tran Thanh Tong Tran Thanh Tong HD 03 D 3 12/19/1961 10/28/1986 50.00 25.0
38 HD053E Nguyen Cong Khanh Nguyen Cong Khanh HD 05 E 3 10/20/1961 10/28/1984 50.00 27.0
39 BC033C Tran Van Ba Tran Van Ba BC 03 C 3 5/13/1967 10/22/1988 44.00 23.0
40 BC033B Nguyen Thi Hao Nguyen Thi Hao BC 03 B 3 10/19/1968 12/31/1995 43.00 16.0
41 BC043C Le Thanh Tong Le Thanh Tong BC 04 C 3 10/9/1972 12/23/1996 39.00 15.0
42 HD033E Ly Van Bap Ly Van Bap HD 03 E 3 2/26/1973 6/26/1991 38.00 21.0
43 BC033B Nguyen Van Xoi Nguyen Van Xoi BC 03 B 3 5/29/1978 6/19/1994 33.00 18.0
44 BC043C Huynh Ngoc Che Che Huynh Ngoc Che Che BC 04 C 3 3/14/1965 9/21/1993 46.00 18.0
45 HD033E Nguyen Manh Dung Nguyen Manh Dung HD 03 E 3 8/26/1974 11/27/1995 37.00 16.0


TUOI NHO NHAT: 33.00 THAM NIEN NHO NHAT 15.0
TUOI LON NHAT 56.00 THAM NIEN LON NHAT 34.0
TUOI TR-BINH 43.42 THAM NIEN TR-BINH 22.5