Dengan tanggal join ada pada sel B5, coba ketik: =DATE(YEAR(B5+2),MONTH(B5),DAY(B5)-1)
Salam, Hendrik Karnadi ________________________________ From: Alni Mainora <[email protected]> To: [email protected] Sent: Tuesday, 4 September 2012, 15:22 Subject: [belajar-excel] Mencari tanggal akhir kontrak Salam para pakar Excel, mohon dicarikan solusi, Jika ada karyawan yang join tgl 04 September 2012 dan 2 tahun kedepan kontraknya akan berakhir, bagaimana cara bikin formulanya ? Contoh data terlampir. Terima kasih banyak atas solusinya. Wassalam, Alni Mainora THIS CORRESPONDENCE CONTAINS CONFIDENTIAL INFORMATION OF KEMET ELECTRONICS CORPORATION AND ITS AFFILIATED COMPANIES. If you have received this e-mail and it was not intended for you, please let us know, and then delete it. We thank you for treating our confidential information in a courteous and professional manner. DISCLAIMER: Although we have taken reasonable steps to reduce risks against viruses, the reliability of this method of communication cannot be guaranteed. It can be intercepted, corrupted, or delayed, or it may arrive incomplete, contain viruses, or be affected by other interference. The opening of any attachments to this e-mail indicates your agreement to hold us harmless and release us from liability for any damage sustained as a result of this transmission.
