{"id":1563,"date":"2023-11-17T05:02:27","date_gmt":"2023-11-17T05:02:27","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/hari-pertama-bulan-ke-2\/"},"modified":"2023-12-06T06:16:11","modified_gmt":"2023-12-06T06:16:11","slug":"hari-pertama-bulan-ke-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/hari-pertama-bulan-ke-2\/","title":{"rendered":"Bagaimana cara mendapatkan hari pertama setiap bulan?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3391598474\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Di Excel, untuk mendapatkan hari pertama setiap bulan, Anda bisa menggunakan rumus. Misalnya, jika Anda memiliki <sup>16<\/sup> Januari 2022 dan ingin mendapatkan <sup>1<\/sup> Januari, Anda dapat mengurangi hari dari hari tersebut dan beralih ke hari terakhir atau bulan sebelumnya, lalu menambahkan satu untuk mendapatkan hari pertama. bulan ini.<\/p><p> Dalam contoh berikut, kita memiliki tanggal di sel A1 dan kita perlu mendapatkan hari pertama pada bulan tersebut. <\/p><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67596\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-de-date-dans-la-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"nilai-tanggal-dalam sel\" width=\"423\" height=\"324\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Rumus untuk mendapatkan tanggal mulai suatu bulan<\/h2><ol type=\"1\"><li> Pertama, masukkan tanda sama dengan di sel B1.<\/li><li> Setelah itu, lihat sel A1 di mana Anda memiliki tanggal sebenarnya dan masukkan operator penjumlahannya.<\/li><li> Sekarang gunakan fungsi DAY dan lihat sel A1.<\/li><li> Selanjutnya, tutup fungsi DAY dan masukkan operator minus.<\/li><li> Pada akhirnya, masukkan \u201c1\u201d dan tekan Enter untuk mendapatkan hasilnya. <\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=A1-DAY(A1)+1<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67597\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-formules-pour-obtenir-la-date-du-debut-du-mois.png\" sizes=\"auto, \" srcset=\"\" alt=\"formula-untuk-mendapatkan-awal-bulan\" width=\"453\" height=\"370\"><\/figure><\/div><p> Untuk memahami rumus ini, Anda perlu membaginya menjadi tiga bagian: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67598\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-formules-reparties.png\" sizes=\"auto, \" srcset=\"\" alt=\"pemisahan rumus\" width=\"448\" height=\"112\"><\/figure><\/div><ol type=\"1\"><li> Pada bagian pertama, kami menggunakan tanggal yang kami miliki di sel A1.<\/li><li> Setelah itu, di bagian kedua, kita menggunakan fungsi DAY dan mendapatkan nomor hari (mengembalikan 16 untuk 16-Jan) dari tanggal aslinya. Dan kami menghapus nomor ini dari tanggal aslinya. Ketika Anda melakukan ini (tanggal \u2013 nomor hari) Anda mendapatkan tanggal akhir bulan lalu.<\/li><li> Sekarang di bagian ketiga kita menambahkan 1 pada tanggal bulan lalu (kita mendapatkannya di bagian kedua) untuk mendapatkan hari pertama bulan ini.<\/li><\/ol><h2 class=\"wp-block-heading\"> Gunakan EOMONTH untuk mendapatkan tanggal awal bulan<\/h2><p> Anda juga dapat menggunakan EOMONTH untuk mendapatkan hari pertama setiap bulan. EOMONTH mengambil tanggal dan membantu Anda mendapatkan tanggal terakhir dalam suatu bulan, dan Anda dapat menambahkan 1 ke tanggal tersebut untuk mendapatkan hari pertama pada bulan tersebut.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=EOMONTH(A1,-1)+1<\/code><\/pre><h2 class=\"wp-block-heading\"> Menggunakan nama bulan untuk mendapatkan hari pertama bulan itu<\/h2><p> Jika Anda ingin membuat janji temu pertama untuk suatu bulan dan ingin menggunakan nama bulan, Anda dapat menggunakan rumus berikut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67599\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Nom-de-4-mois-pour-obtenir-le-premier-jour.png\" sizes=\"auto, \" srcset=\"\" alt=\"nama-bulan-untuk-mendapatkan-hari pertama\" width=\"438\" height=\"317\"><\/figure><\/div><p> Rumus ini membuat tanggal dengan menggabungkan hari, bulan, dan tahun dan mengubahnya menjadi tanggal sebenarnya. Untuk hari kita sudah menggunakan 1, untuk bulan kita menggunakan nama bulan dari sel A3, dan untuk tahun kita menggunakan nilai dari sel A4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67600\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-formule-de-valeur-de-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"rumus nilai tanggal\" width=\"506\" height=\"304\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=DATEVALUE(\"1\"&amp;\"-\"&amp;A3&amp;\"-\"&amp;A4)<\/code><\/pre><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/premier-jour-du-mois.xlsx\" rel=\"nofollow\">Unduh<\/a><\/p><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">Daftar rumus Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/menambahkan-satu-bulan-ke-tanggal-2\/\">Tambahkan bulan ke tanggal di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/akhir-bulan\/\">Dapatkan tanggal akhir bulan di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/nama-bulannya\/\">Dapatkan bulan dari tanggal di Excel (kutipan)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/seperempat\/\">Dapatkan seperempat dari tanggal [Fiskal + Kalender] di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/bulan-di-antara-dua-tanggal\/\">Jumlah bulan antara dua tanggal di Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1563","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Bagaimana cara mendapatkan hari pertama setiap bulan? - Penasihat Excel<\/title>\n<meta name=\"description\" content=\"Dalam tutorial rumus ini, kita akan mempelajari cara mendapatkan hari (tanggal) pertama suatu bulan dengan menggunakan dua metode berbeda.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/hari-pertama-bulan-ke-2\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara mendapatkan hari pertama setiap bulan? - Penasihat Excel\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial rumus ini, kita akan mempelajari cara mendapatkan hari (tanggal) pertama suatu bulan dengan menggunakan dua metode berbeda.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/hari-pertama-bulan-ke-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:16:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-de-date-dans-la-cellule.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/hari-pertama-bulan-ke-2\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/hari-pertama-bulan-ke-2\/\",\"name\":\"\u25b7 Bagaimana cara mendapatkan hari pertama setiap bulan? - Penasihat Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hari-pertama-bulan-ke-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hari-pertama-bulan-ke-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-de-date-dans-la-cellule.png\",\"datePublished\":\"2023-11-17T05:02:27+00:00\",\"dateModified\":\"2023-12-06T06:16:11+00:00\",\"description\":\"Dalam tutorial rumus ini, kita akan mempelajari cara mendapatkan hari (tanggal) pertama suatu bulan dengan menggunakan dua metode berbeda.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hari-pertama-bulan-ke-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/hari-pertama-bulan-ke-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/hari-pertama-bulan-ke-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-de-date-dans-la-cellule.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-de-date-dans-la-cellule.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/hari-pertama-bulan-ke-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mendapatkan hari pertama setiap bulan?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Bagaimana cara mendapatkan hari pertama setiap bulan? - Penasihat Excel","description":"Dalam tutorial rumus ini, kita akan mempelajari cara mendapatkan hari (tanggal) pertama suatu bulan dengan menggunakan dua metode berbeda.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/id\/hari-pertama-bulan-ke-2\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara mendapatkan hari pertama setiap bulan? - Penasihat Excel","og_description":"Dalam tutorial rumus ini, kita akan mempelajari cara mendapatkan hari (tanggal) pertama suatu bulan dengan menggunakan dua metode berbeda.","og_url":"https:\/\/exceladvisor.org\/id\/hari-pertama-bulan-ke-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:16:11+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-de-date-dans-la-cellule.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/hari-pertama-bulan-ke-2\/","url":"https:\/\/exceladvisor.org\/id\/hari-pertama-bulan-ke-2\/","name":"\u25b7 Bagaimana cara mendapatkan hari pertama setiap bulan? - Penasihat Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/hari-pertama-bulan-ke-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/hari-pertama-bulan-ke-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-de-date-dans-la-cellule.png","datePublished":"2023-11-17T05:02:27+00:00","dateModified":"2023-12-06T06:16:11+00:00","description":"Dalam tutorial rumus ini, kita akan mempelajari cara mendapatkan hari (tanggal) pertama suatu bulan dengan menggunakan dua metode berbeda.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/hari-pertama-bulan-ke-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/hari-pertama-bulan-ke-2\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/hari-pertama-bulan-ke-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-de-date-dans-la-cellule.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-de-date-dans-la-cellule.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/hari-pertama-bulan-ke-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mendapatkan hari pertama setiap bulan?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1563","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1563"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1563\/revisions"}],"predecessor-version":[{"id":2503,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1563\/revisions\/2503"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1563"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}