{"id":188,"date":"2021-07-02T15:16:08","date_gmt":"2021-07-02T15:16:08","guid":{"rendered":"https:\/\/excelforgbs.com\/?page_id=188"},"modified":"2022-06-10T17:29:04","modified_gmt":"2022-06-10T17:29:04","slug":"date-and-time-functions","status":"publish","type":"page","link":"https:\/\/excelforgbs.com\/?page_id=188","title":{"rendered":"Date And Time Functions"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The first video discusses how dates and times are stored in spreadsheets.  <a href=\"https:\/\/excelforgbs.com\/?p=299\">Dates and Times<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">There are functions to access the parts of Dates:  MONTH(), DAY() and YEAR().  These functions are for Times: HOUR(), MINUTE() and SECOND().   <a href=\"https:\/\/excelforgbs.com\/?p=303\">Functions to manipulate Dates and Times<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">There are also some special functions to help manipulate Dates.  Get dates for elapsed time, EDATE() and EOMONTH().  Find which day of the week a date is with WEEKDAY(), and find the week number during the year for a date with WEEKNUM().  <a href=\"https:\/\/excelforgbs.com\/?p=309\">Other Date Functions<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/excelforgbs.com\/?page_id=190\">Next Page:  Lookup Functions<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The first video discusses how dates and times are stored in spreadsheets. Dates and Times There are functions to access the parts of Dates: MONTH(), DAY() and YEAR(). These functions are for Times: HOUR(), MINUTE() and SECOND(). Functions to manipulate Dates and Times There are also some special functions to help manipulate Dates. Get dates &hellip; <a href=\"https:\/\/excelforgbs.com\/?page_id=188\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Date And Time Functions<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":30,"menu_order":30,"comment_status":"closed","ping_status":"closed","template":"","meta":{"nf_dc_page":"","_monsterinsights_skip_tracking":false,"footnotes":""},"class_list":["post-188","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/pages\/188","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"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=188"}],"version-history":[{"count":5,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/pages\/188\/revisions"}],"predecessor-version":[{"id":332,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/pages\/188\/revisions\/332"}],"up":[{"embeddable":true,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/pages\/30"}],"wp:attachment":[{"href":"https:\/\/excelforgbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=188"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}