coba dengan bantuan kolom bantu untuk membuat format tanggalnya.. file terlampir.
> Minta tolong gimana caranya kolom tanggal bisa dicari hari nya? > Saya sudah gunakan rumus TEXT sampe VLOOKUP tetapi masih ga bisa, kecuali > tanggal yg ada dikolom tersebut benar-benar format tanggal. Ini karena > data > yang diambil langsung dari mesin absen sehingga penulisannya seperti itu. > > Mohon Bantuannya, > Regards, > Annisa ABSEN_16-AUG-12_-_31-AUG-12_(2)_+_rumus.xlsx > <http://milis-belajar-excel.1048464.n5.nabble.com/file/n5712155/ABSEN_16-AUG-12_-_31-AUG-12_%282%29_%2B_rumus.xlsx> > > > > -- > View this message in context: > http://milis-belajar-excel.1048464.n5.nabble.com/Minta-tolong-gimana-caranya-cari-hari-dari-tanggal-tp5712155.html > Sent from the Milis Belajar Excel mailing list archive at Nabble.com. > ____________ _________ _________ _________ _________ _________ _________ Notice : This e-mail (and any attachment) is strictly confidential and is intended only for the addressee(s)above. Is strictly prohibited to forward, print, copy, or otherwise reproduce this message that would allow it to be viewed by any individual not originally listed as a recipient(s). If you have received this e-mail in error, please immediately notify the sender and delete this message. The opinions expressed in this e-mail (and any attachment) are those of the individual sender and may not necessarily reflect the views of PT Pusri. ____________ _________ _________ _________ _________ _________ _________
Copy of ABSEN_16-AUG-12_-_31-AUG-12_(2)_+_rumus.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
