cara menghitung usia-masa kerja2
DESCRIPTION
kerjaTRANSCRIPT
PROGRAM MENGHITUNG USIA DAN MASA KERJA
No Nama Pegawai Tanggal lahirUmur
Tahun Bulan
1 Abdullah 3/1/1991 25 1
2 Budiman 5/18/1993 22 10
3 Chyntia 6/20/1994 21 9
4 Diego 4/6/1990 26 0
5 Evellyn 3/12/1992 24 0
6 Farid 3/1/1987 29 1
7 Gabriel 4/1/1986 30 0
8 Hendry 6/12/1990 25 9
9 Intan 4/9/1990 25 11
10 Jefry 5/9/1993 22 10
11 3/31/1985 31 0
Untuk Jefry : =INT((TODAY()-C16/365.25)
=INT((TODAY()-C16/30.4375)-D16*12
=INT((TODAY()-F16/365.25)
=INT((TODAY()-F16/30.4375)-G16*12
PROGRAM MENGHITUNG USIA DAN MASA KERJA
TMTMasa Kerja
Tahun Bulan
4/21/2010 5 11
4/22/2010 5 11
4/23/2010 5 11
8/9/2011 4 7
8/10/2011 4 7
8/11/2011 4 7
8/12/2011 4 7
6/30/2012 3 9
7/1/2012 3 9
7/2/2012 3 9
10/3/2010 5 6
=INT((TODAY()-C16/365.25)
=INT((TODAY()-C16/30.4375)-D16*12
=INT((TODAY()-F16/365.25)
=INT((TODAY()-F16/30.4375)-G16*12