Dear Raymond Menggunakan Formula DATEDIF saja
saya kasi Guide nya untuk Formula ini ya : =DATEDIF(Date1, Date2, Interval) Where: Date1 is the first date, Date2 is the second date, Interval is the interval type to return. If Date1 is later than Date2, DATEDIF will return a #NUM! error. If either Date1 or Date2 is not a valid date, DATEDIF will return a #VALUE error. The Interval value should be one of Interval Meaning Description m Months Complete calendar months between the dates. d Days Number of days between the dates. y Years Complete calendar years between the dates. ym Months Excluding Years Complete calendar months between the dates as if they were of the same year. yd Days Excluding Years Complete calendar days between the dates as if they were of the same year. md Days Excluding Years And Months Complete calendar days between the dates as if they were of the same month and same year. ________________________________ Dari: Raymond Adry <[email protected]> Kepada: [email protected] Dikirim: Kamis, 24 Januari 2013 9:07 Judul: ]] XL-mania [[ Mencari umur Mohon bantuannya bagaimana menampakkan umur dari tanggal lahir seseorang Seperti pada table dibawah ini No. Nama No Pegawai Tanggal lahir Umur 1 Herry C Pelealu 01575 23-Jan-60 <-- pada kolom ini yang ditampilkan adalah umurnya = 52 2 Marthen Mantiri 01573 23-Mar-55 3 Supriyono 04621 27-Mar-63 4 Yusak Bulo' 01548 5-Jul-57 5 Djaelani 01244 2-Jan-59 6 Mudjib 01156 12-May-56 Terima kasih banyak Wasalam Raymond AR Northern Area Disclaimer: The contents of this email, together with its attachments, may contain confidential information belong to Virginia Indonesia Co., LLC (“VICO”) and Virginia Indonesia Co., CBM Limited (“VICO CBM”). If you are not the intended recipient, please notify the sender immediately and delete this e-mail from your system, and you should not disseminate, distribute, copy or otherwise use this email or any part thereof.
