{"id":4449,"date":"2023-07-11T00:47:33","date_gmt":"2023-07-11T00:47:33","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-hari-pertama-setiap-bulan\/"},"modified":"2023-07-11T00:47:33","modified_gmt":"2023-07-11T00:47:33","slug":"google-sheet-hari-pertama-setiap-bulan","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-hari-pertama-setiap-bulan\/","title":{"rendered":"Cara mendapatkan hari pertama setiap bulan di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan salah satu rumus berikut untuk mendapatkan hari pertama setiap bulan untuk suatu tanggal di Google Spreadsheet:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Rumus 1: gunakan fungsi DAY()<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">= <span style=\"color: #ff6600;\">A2<\/span> -DAY( <span style=\"color: #ff6600;\">A2<\/span> )+ <span style=\"color: #3366ff;\">1\n<\/span><\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Rumus 2: Gunakan fungsi EOMONTH()<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=EOMONTH( <span style=\"color: #ff6600;\">A2<\/span> , <span style=\"color: #3366ff;\">-1<\/span> ) <span style=\"color: #3366ff;\">+1\n<\/span><\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Kedua rumus akan mengembalikan hari pertama setiap bulan untuk tanggal di sel <strong>A2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap rumus dalam praktik dengan kumpulan data berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34842 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fd11.png\" alt=\"\" width=\"530\" height=\"475\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Dapatkan hari pertama setiap bulan menggunakan DAY()<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>C2<\/strong> untuk mendapatkan hari pertama setiap bulan untuk tanggal di sel <strong>A2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">= <span style=\"color: #ff6600;\">A2<\/span> -DAY( <span style=\"color: #ff6600;\">A2<\/span> )+ <span style=\"color: #3366ff;\">1<\/span><\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyeret dan mengisi rumus ini ke setiap sel yang tersisa di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34843 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fd12.png\" alt=\"\" width=\"536\" height=\"457\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom C sekarang menampilkan hari pertama setiap bulan untuk setiap tanggal di kolom A.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Begini cara kerja rumus ini:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Fungsi <strong>DAY()<\/strong> mengembalikan hari dalam sebulan antara 1 dan 31.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Jadi, <strong>A2 \u2013 DAY(A2)<\/strong> mengembalikan hari terakhir bulan sebelumnya.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Lalu kita tambahkan satu untuk mendapatkan hari pertama setiap bulan untuk tanggal di sel <strong>A2<\/strong> .<\/span><\/li>\n<\/ul>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2:<\/strong><\/span> <span style=\"color: #000000;\"><strong>Dapatkan hari pertama setiap bulan menggunakan EOMONTH()<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa mengetikkan rumus berikut di sel <strong>C2<\/strong> untuk mendapatkan hari pertama setiap bulan untuk tanggal di sel <strong>A2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=EOMONTH( <span style=\"color: #ff6600;\">A2<\/span> , <span style=\"color: #3366ff;\">-1<\/span> ) <span style=\"color: #3366ff;\">+1<\/span><\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyeret dan mengisi rumus ini ke setiap sel yang tersisa di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-34844\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fd13.png\" alt=\"Google Spreadsheet mendapat hari pertama setiap bulan\" width=\"527\" height=\"458\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom C sekarang menampilkan hari pertama setiap bulan untuk setiap tanggal di kolom A.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Begini cara kerja rumus ini:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Fungsi <strong>EOMONTH()<\/strong> mengembalikan hari terakhir suatu bulan untuk suatu tanggal.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Fungsi <strong>EOMONTH(A2, -1)<\/strong> mengembalikan hari terakhir bulan sebelumnya.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Lalu kita tambahkan satu untuk mendapatkan hari pertama setiap bulan untuk tanggal di sel <strong>A2<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Anda dapat menemukan dokumentasi lengkap fungsi <strong>EOMONTH()<\/strong> di Google Spreadsheet <a href=\"https:\/\/support.google.com\/docs\/answer\/3093044?hl=en\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/google-sheet-mengubah-hari-menjadi-bulan\/\" target=\"_blank\" rel=\"noopener\">Cara mengubah hari menjadi bulan di Google Sheets<\/a><br \/>Cara menghitung berdasarkan bulan di Google Sheets<br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-mengonversi-tanggal-menjadi-bulan-dan-tahun\/\" target=\"_blank\" rel=\"noopener\">Cara mengubah tanggal menjadi bulan dan tahun di Google Sheets<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan salah satu rumus berikut untuk mendapatkan hari pertama setiap bulan untuk suatu tanggal di Google Spreadsheet: Rumus 1: gunakan fungsi DAY() = A2 -DAY( A2 )+ 1 Rumus 2: Gunakan fungsi EOMONTH() =EOMONTH( A2 , -1 ) +1 Kedua rumus akan mengembalikan hari pertama setiap bulan untuk tanggal di sel A2 . [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara mendapatkan hari pertama setiap bulan di Google Sheets \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mendapatkan hari pertama setiap bulan di Google Sheets, beserta contohnya.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/google-sheet-hari-pertama-setiap-bulan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara mendapatkan hari pertama setiap bulan di Google Sheets \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mendapatkan hari pertama setiap bulan di Google Sheets, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-hari-pertama-setiap-bulan\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T00:47:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fd11.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-hari-pertama-setiap-bulan\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-hari-pertama-setiap-bulan\/\",\"name\":\"Cara mendapatkan hari pertama setiap bulan di Google Sheets \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T00:47:33+00:00\",\"dateModified\":\"2023-07-11T00:47:33+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mendapatkan hari pertama setiap bulan di Google Sheets, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-hari-pertama-setiap-bulan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-hari-pertama-setiap-bulan\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-hari-pertama-setiap-bulan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mendapatkan hari pertama setiap bulan di google sheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara mendapatkan hari pertama setiap bulan di Google Sheets \u2013 Statologi","description":"Tutorial ini menjelaskan cara mendapatkan hari pertama setiap bulan di Google Sheets, beserta contohnya.","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:\/\/statorials.org\/id\/google-sheet-hari-pertama-setiap-bulan\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mendapatkan hari pertama setiap bulan di Google Sheets \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara mendapatkan hari pertama setiap bulan di Google Sheets, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/google-sheet-hari-pertama-setiap-bulan\/","og_site_name":"Statorials","article_published_time":"2023-07-11T00:47:33+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fd11.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/google-sheet-hari-pertama-setiap-bulan\/","url":"https:\/\/statorials.org\/id\/google-sheet-hari-pertama-setiap-bulan\/","name":"Cara mendapatkan hari pertama setiap bulan di Google Sheets \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T00:47:33+00:00","dateModified":"2023-07-11T00:47:33+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mendapatkan hari pertama setiap bulan di Google Sheets, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-hari-pertama-setiap-bulan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-hari-pertama-setiap-bulan\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-hari-pertama-setiap-bulan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mendapatkan hari pertama setiap bulan di google sheets"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4449"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=4449"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4449\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4449"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4449"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4449"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}