Wa'alaykum salam.. Mas Shino;
Coba tambah rumusnya menjadi seperti ini: =IF(TEXT(B3,"m")-TEXT(TODAY(),"m")=3,"Jatuh Tempo kurang "&TEXT(B3,"m")-TEXT(TODAY(),"m")&" Bulan atau "&B3-TODAY()&" hari lagi",IF((B3=TODAY()),"Jatuh Tempo tiba pada hari ini",IF(B3-TODAY()>0,"Jatuh tempo tinggal "&B3-TODAY()&" Hari","Jatuh tempo Lebih "&ABS(B3-TODAY())&" Hari"))) Wassalam ~ Bagus ~ ----- Original Message ----- From: Zahdan Shino To: [email protected] Sent: Wednesday, March 27, 2013 9:42 AM Subject: [belajar-excel] jatuh tempo assalamu alaikum... mas, mohon pencerahan pada case ini. ini tentang jatuh tempo.... terima kasih sebelumnya. assalamu alaikum....
