Anda Bertanya Kami Menjawab All About Microsoft Office 2007 Word, Excel, Powerpoint
=Sheet1!A1+Sheet1!B1 Gunakan menu Data -> Text to Columns -> separator , kemudian format hasil split nya (kira-kira begitu :D) =DATEDIF(A1,EDATE(TODAY(),24),"y") &" thn "&DATEDIF(A1,EDATE(TODAY(),24),"ym") &" bln" *asumsi mulai angsuran hari ini, sila...