"Seandainya di depan mataku ini ada tembok berwarna putih, lalu Muhammad mengatakan bahwa tembok itu berwarna hitam, maka aku akan bohongkan mataku, dan akan kukatakan bahwa tembok itu berwarna hitam!". (perkataan Abu Bakar radhiallahu anhu, dinukil dari ceramah sejarah Nabi, oleh Khalid Basalamah)

22 Desember 2014

Excel Tips: Menghitung Usia

Dulu saya pernah sharing tips excel utk menggabungkan dua cell, kali ini adalah tips utk menghitung umur/ usia..
Syntaxnya:
  =DATEDIF(cell tgl lahir,TODAY(),"y") -----> tahun
  =DATEDIF(cell tgl lahir,TODAY(),"ym") ---> bulan
  =DATEDIF(cell tgl lahir,TODAY(),"md") ---> hari

Untuk mengetahui usia object pada tanggal tertentu, maka function TODAY() diganti menjadi tanggal yang diinginkan (gunakan format tanggal normal dd/mm/yyyy).

Untuk menggabungkan seluruh tahun, bulan dan harinya, maka sintaxmya sbb:
="Age is "&DATEDIF(C8,TODAY(),"y")&" Years, "&DATEDIF(C8,TODAY(),"ym")&" Months and "&DATEDIF(C8,TODAY(),"md")&" Days"

C8 adalah posisi tanggal lahirnya.

*) Perhatikan tanda pemisah "," (koma), utk regional setting yg berbeda bisa diganti menjadi ";" (titik koma)

Semoga bermanfaat.. :)

24 Agustus 2013

Some tools and supplies for your own hotel


Do you looking for tools for your own hotel, or perhaps some furniture or bar supplies? Then you have to browse from Hotel Suppy Online in PeachSuite.


Family owned and operated since 1981, they operate as a full-line stocking, wholesale distributor of many different products for many different customers. They move product from point A to point B in whatever quantity and in whichever fashion the customer desires. They provide services and products for those people or businesses looking for MORE...Value...Attention...Rest & Relaxation...

This Atlanta Hotel Supply strive to provide MORE Products and MORE Services with MORE Value and MORE Options. They even deliver MORE Hotel Bar Supplies with friendly price.