Teman BeExcel Mohon bantuan, Kenapa return value nya 1903 dan bukan 2013? =DATE(RIGHT(A1,4),MID(A1,4,3),LEFT(A1,2)) Terima kasih. -Emi 04.07.2013 04/07/1903 21.06.2013 21/06/1903 22.06.2013 22/06/1903 18.06.2013 18/06/1903 19.06.2013 19/06/1903 25.06.2013 25/06/1903 25.06.2013 25/06/1903 13.07.2013 13/07/1903 12.07.2013 12/07/1903 10.07.2013 10/07/1903
Text to date.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
