Coba sertakan juga harusnya jadi tanggal berapa kalau dikerjakan manual. Kid.
On Tue, Mar 6, 2012 at 15:36, Mansor <[email protected]> wrote: > ** > > > 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 >>>> >>>> >>>> >>>> >>> >> > >
