{"id":8571,"date":"2018-06-12T16:45:53","date_gmt":"2018-06-12T14:45:53","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=8571"},"modified":"2018-06-12T16:45:53","modified_gmt":"2018-06-12T14:45:53","slug":"formula-de-dia-no-planilhas-google","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/google-sheets-formulas\/day-formula-in-google-sheets\/","title":{"rendered":"Como usar a f\u00f3rmula DAY no Planilhas Google"},"content":{"rendered":"\n[et_pb_section fb_built=”1″ admin_label=”section” module_class=”sheetgo-post” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

There can be situations where we\u2019d like to extract the day of the month from a given date. Probably to use it with another formula that decides if it falls in the first half or second half of the month. On a quick look, we can quickly identify the day of the month. But the machine doesn\u2019t know it directly. Because a date is just a numeric value for any spreadsheets application. For example, the underlying numeric value for the\u00a0date \u201c7-Jun-2018\u201d is 43,258. So how do we extract the day of the month from this numeric value? The\u00a0<\/span>DAY<\/a>\u00a0<\/span>formula is available for just this purpose, to calculate\u00a0<\/em><\/strong>the<\/em>\u00a0<\/span>Google Sheets day of month formula<\/em><\/strong>.<\/p>\n

Syntax<\/h3>\n

DAY(date)<\/strong><\/p>\n

date<\/strong>\u00a0<\/span>\u2013 is the date which we need to extract the day from. This input has to be a date type data.\u00a0We can\u00a0ensure that either by using formulas such as\u00a0DATE<\/a>, DATEVALUE or TO_DATE that return date objects. Or we may also use\u00a0references to the cells that have dates or numbers.<\/p>\n

 <\/p>[\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

Usage: Google Sheets day of month formula<\/h3>\n

The syntax we just learned\u00a0suggests that the DAY formula in Google Sheets is pretty simple and straightforward. Let us further reinforce our understanding with the help of a few practical examples.<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/google-sheets-day-of-month-1.png” alt=”google sheets day of month 1″ title_text=”google sheets day of month 1″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

As you may have noticed we have tried various ways in which we can pass the input parameter value. In the first example, we passed a valid date string, and the formula, as expected returned 7. The second example demonstrates the capability of the formula to accept the references to cells that have dates within them. The third example worked even when there\u2019s a number on the cell. Co-incidentally the number 43,258 is equivalent to the date 7-Jun-2017 in Google Sheets. Hence it returned the value 7. On the fourth example, we tried embedding a DATE function within the formula.<\/p>\n

While the first four examples demonstrate the working of the formula itself, we tried more practical examples on the rows 6 and 7.\u00a0Here we are trying to deduce whether a day belongs to the first half of the month or the second. And the composite formula delivers its job religiously indicating which day belongs to which half.<\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"

There can be situations where we\u2019d like to extract the day of the month from a given date. Probably to use it with another formula that decides if it falls in the first half or second half of the month. On a quick look, we can quickly identify the day of the month. But the […]<\/p>\n","protected":false},"author":40,"featured_media":8575,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"There can be situations where we'd like to extract the day of the month from a given date. Probably to use it with another formula that decides if it falls in the first half or second half of the month. On a quick look, we can quickly identify the day of the month. But the machine doesn't know it directly. Because a date is just a numeric value for any spreadsheets application. For example, the underlying numeric value for the\u00a0date \"7-Jun-2018\" is 43,258. So how do we extract the day of the month from this numeric value? The DAY<\/a> formula in Google Sheets is just available for this purpose.\n

Syntax<\/h3>\nDAY(date)<\/strong>\n\ndate<\/strong> - is the date which we need to extract the day from. This input has to be a date type data.\u00a0We can\u00a0ensure that either by using formulas such as\u00a0DATE<\/a>, DATEVALUE or TO_DATE that return date objects. Or we may also use\u00a0references to the cells that have dates or numbers.\n

Usage: DAY formula in Google Sheets<\/h3>\nThe syntax we just learned\u00a0suggests that it is a pretty simple and straightforward formula. Let us further reinforce our understanding with the help of a few practical examples.\n\n\"DAY\n\nAs you may have noticed we have tried various ways in which we can pass the input parameter value. In the first example, we passed a valid date string, and the formula, as expected returned 7. The second example demonstrates the capability of the formula to accept the references to cells that have dates within them. The third example worked even when there's a number on the cell. Co-incidentally the number 43,258 is equivalent to the date 7-Jun-2017 in Google Sheets. Hence it returned the value 7. On the fourth example, we tried embedding a DATE function within the formula.\n\nWhile the first four examples demonstrate the working of the formula itself, we tried more practical examples on the rows 6 and 7.\u00a0Here we are trying to deduce whether a day belongs to the first half of the month or the second. And the composite formula delivers its job religiously indicating which day belongs to which half.","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[55,39,28],"class_list":["post-8571","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-ben-collins","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/8571","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=8571"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/8571\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/8575"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=8571"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=8571"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=8571"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}