Mr Kid, Terima kasih rumus yang bapak ajarkan. Tetapi setelah dicoba beberapa kali, ternyata masih terdapat error. File nya dilampirkan
terima kasih. Mansor Text Error Value 01/05/2011 1-May-11 01/12/2011 1-Dec-11 01/12/2011 1-Dec-11 01/12/2011 1-Dec-11 01/13/2011 #VALUE! 01/13/2011 #VALUE! 01/31/2011 #VALUE! 01/31/2011 #VALUE! 01/31/2011 #VALUE! 02/01/2011 2-Jan-11 02/10/2011 2-Oct-11 02/10/2011 2-Oct-11 02/10/2011 2-Oct-11 02/10/2011 2-Oct-11 02/11/2011 2-Nov-11 02/12/2011 2-Dec-11 02/13/2011 #VALUE! 02/14/2011 #VALUE! 02/28/2011 #VALUE! On Mon, Mar 5, 2012 at 2:06 PM, Mansor <[email protected]> wrote: > Terima kasih Mr Kid. > Rumusnya sudah berhasil > -Mansor > > On Mon, Mar 5, 2012 at 1:22 PM, Kid Mr. <[email protected]> wrote: > >> ** >> >> >> Dear Mansor, >> >> Coba formula : >> >> =IF(ISNUMBER(-B2),--TEXT(B2,"YYYY-DD-MM"),DATE(RIGHT(B2,4),MID(B2,4,2),LEFT(B2,2))) >> >> Regards. >> Kid. >> >> >> On Mon, Mar 5, 2012 at 11:19, Mansor <[email protected]> wrote: >> >>> ** >>> >>> >>> >>> >>> Dear teman beExcel >>> >>> Komputer saya settingnya English US. >>> >>> Saya punya data seperti di Kolum order date. >>> >>> Range B2: B33 adalah format date d/m/yy. >>> >>> Range B34: B54 adalah TEXT walaupun keliatan seperti tanggal. >>> >>> Saya coba convert dari TEXT ke tanggal seperti di Kolum C34:C54 >>> >>> =DATE(RIGHT(B34,4),MID(B34,4,2),LEFT(B34,2)) >>> >>> Hasilnya date valuenya ialah m/d/yyyy >>> >>> Tetapi jika dibuat pivot table , hasil tanggalnya berbeda. >>> >>> Terima kasih >>> >>> -Mansor >>> >>> >>> >>> >> >> > >
Format Tanggal yang berbeda1.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
