{"id":309,"date":"2022-06-09T16:33:29","date_gmt":"2022-06-09T16:33:29","guid":{"rendered":"https:\/\/excelforgbs.com\/?p=309"},"modified":"2022-06-09T16:33:29","modified_gmt":"2022-06-09T16:33:29","slug":"other-date-functions","status":"publish","type":"post","link":"https:\/\/excelforgbs.com\/?p=309","title":{"rendered":"Other Date Functions"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Since months are different lengths and years start on different days, there are functions in Excel to handle these details.  EDATE() increments dates by one month (whether that is a 30 or 31 day month).  EOMONTH() increments a date to the end of a month (either 30 or 31).  WEEKDAY() returns the day of the week (1-7) for a date.  And WEEKNUM() returns the week number for a date (useful for collecting weekly sales totals).<\/p>\n\n\n\n<figure class=\"wp-block-video\"><video controls src=\"https:\/\/excelforgbs.com\/video\/Functions\/Date\/OtherDateFunctions.mp4\"><\/video><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Since months are different lengths and years start on different days, there are functions in Excel to handle these details. EDATE() increments dates by one month (whether that is a 30 or 31 day month). EOMONTH() increments a date to the end of a month (either 30 or 31). WEEKDAY() returns the day of the &hellip; <a href=\"https:\/\/excelforgbs.com\/?p=309\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Other Date Functions<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","_monsterinsights_skip_tracking":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-309","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/posts\/309","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=309"}],"version-history":[{"count":1,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/posts\/309\/revisions"}],"predecessor-version":[{"id":310,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/posts\/309\/revisions\/310"}],"wp:attachment":[{"href":"https:\/\/excelforgbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=309"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=309"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=309"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}