thanks pa akan saya lakukan
From: Kid Mr.
To: belajar-excel@yahoogroups.com
Sent: Friday, June 15, 2012 10:08 AM
Subject: Re: [belajar-excel] Mohon pencerahannya "membuat schedule angsuran
otomatis sesuai periode akuntansi"
Silakan dicoba
Silakan dicoba :
header tanggal :
kolom ke-1 ( i4 ) :
=F1-DAY(F1)+1
kolom ke-2 dst (mulai j4 ke kanan) :
=I4+34-DAY(I4+33)
schedule angsuran ( i5 ) :
=IF(N($E5),(COUNTIF($H5:H5,">0")$E5-DAY($E5))*(I$4-1+DAY($E5)),0)
kemudian :
>> klik kanan i5 -> format cells -> number -> custom -> isi di textbo
2 matches
Mail list logo