{"id":3174,"date":"2021-03-28T18:38:08","date_gmt":"2021-03-29T01:38:08","guid":{"rendered":"https:\/\/SUMMALAI.COM\/?p=3174"},"modified":"2021-03-31T08:53:37","modified_gmt":"2021-03-31T15:53:37","slug":"how-to-use-date-and-eomonth-to-get-first-day-and-last-day-of-the-month-and-year","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=3174","title":{"rendered":"How to Use DATE and EOMONTH to Get First Day and Last Day of the Month and Year."},"content":{"rendered":"\n<p><strong>On this page, you will find some formulas to calculate specific days automatically<\/strong>. Building specific dates, such as the first or last day, is always a very complex task, in Excel or any other software.<\/p>\n\n\n\n<p>The function TODAY has been used in all the examples but you can replace it with your own date value.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">First day &#8211; Last day of the month<\/h3>\n\n\n\n<p>These calculations is really easy to do with&nbsp;the DATE&nbsp;function.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">First day of the month<\/h3>\n\n\n\n<p>=DATE(YEAR(TODAY()),MONTH(TODAY()),1)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Calculate First Day of the Month with EOMONTH<\/h3>\n\n\n\n<p>There\u2019s no Excel function to calculate the first day of the month, but the&nbsp;EOMONTH function will calculate the last day of a month.<\/p>\n\n\n\n<p>To find the first day of a month we will calculate the last day of the previous month and add one day.<\/p>\n\n\n\n<p>=EOMONTH(B3,-1)<\/p>\n\n\n\n<p>Here let\u2019s find the last day of the previous month:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.automateexcel.com\/excel\/wp-content\/uploads\/2020\/04\/Last-day-of-Previous-Month.png\" alt=\"Last day of Previous Month\" class=\"wp-image-16809\"\/><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Last day of the month<\/h3>\n\n\n\n<p>In Excel, 1 is one day and not one hour. So using this rule, we just have to subtract 1 from the formula that calculates the first day of the next month.<\/p>\n\n\n\n<p>=DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)-1<\/p>\n\n\n\n<p>Or you can use the function EOMONTH<\/p>\n\n\n\n<p>=EOMONTH(TODAY(),0)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">First Monday of the month<\/h3>\n\n\n\n<p>=TODAY()-DAY(TODAY())+8-WEEKDAY(TODAY()-DAY(TODAY())+6)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Last Monday of the month<\/h3>\n\n\n\n<p>=DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)-WEEKDAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,6))<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Examples with the date of TODAY<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\">Next Quarter<\/h3>\n\n\n\n<p>If you want to return the first day of the current quarter, we need to use the MOD function to return a gap of 0, 1 or 2 months<\/p>\n\n\n\n<p>=DATE(YEAR(B2);MONTH(B2)-MOD(MONTH(B2)-1;3);1)<\/p>\n\n\n\n<p>And to return the first day of the next quarter, the formula is<\/p>\n\n\n\n<p>=DATE(YEAR(B2);MONTH(B2)-MOD(MONTH(B2)-1;3)+3;1)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">First day &#8211; Last day of the year<\/h3>\n\n\n\n<h3 class=\"wp-block-heading\">First day of the year<\/h3>\n\n\n\n<p>=DATE(YEAR(TODAY()),1,1)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Last day of the year<\/h3>\n\n\n\n<p>=DATE(YEAR(TODAY())+1,1,0)<\/p>\n\n\n\n<p>or<\/p>\n\n\n\n<p>=DATE(YEAR(TODAY()),12,31)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">First Monday of the year<\/h3>\n\n\n\n<p>=DATE(YEAR(TODAY()),1,8)-WEEKDAY(DATE(YEAR(TODAY()),1,6))<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Last Monday of the year<\/h3>\n\n\n\n<p>=DATE(YEAR(TODAY())+1,1,0)-WEEKDAY(DATE(YEAR(TODAY()),1,6))<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Number of days in the month<\/h3>\n\n\n\n<p>A very important and often ignored piece of information is the number of days in a month. For monthly reports, this information is very important.<\/p>\n\n\n\n<p>The following formulas allow you to return the number of days in a month.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Number of days in the current month<\/h3>\n\n\n\n<p>=DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)-1)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Number of days in the next month<\/h3>\n\n\n\n<p>=DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+2,1)-1)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Number of days in the previous month<\/h3>\n\n\n\n<p>=DAY(DATE(YEAR(TODAY()),MONTH(TODAY()),1)-1)<\/p>\n\n\n\n<p>Ref: <a href=\"https:\/\/www.excel-exercise.com\/first-day-last-day-in-excel\/\">Return the first day or the last day (Month, Quarter, Year) &#8211; Excel Exercise (excel-exercise.com)<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>On this page, you will find some formulas to calculate specific days automatically. Building specific dates, such as the first or last day, is always a very complex task, in Excel or any other software. The function TODAY has been used in all the examples but you can replace it with your own date value. <a class=\"read-more\" href=\"https:\/\/SUMMALAI.COM\/?p=3174\">Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,18],"tags":[659],"class_list":["post-3174","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-office","tag-eomonth"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"On this page, you will find some formulas to calculate specific days automatically. Building specific dates, such as the first or last day, is always a very complex task, in Excel or any other software. The function TODAY has been used in all the examples but you can replace it with your own date value.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Summa Lai\"\/>\n\t<meta name=\"keywords\" content=\"eomonth,microsoft family,microsoft office\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/SUMMALAI.COM\/?p=3174\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3174#article\",\"name\":\"How to Use DATE and EOMONTH to Get First Day and Last Day of the Month and Year. | Summa Lai\",\"headline\":\"How to Use DATE and EOMONTH to Get First Day and Last Day of the Month and Year.\",\"author\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?author=2#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.automateexcel.com\\\/excel\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/Last-day-of-Previous-Month.png\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3174\\\/#articleImage\"},\"datePublished\":\"2021-03-28T18:38:08-07:00\",\"dateModified\":\"2021-03-31T08:53:37-07:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3174#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3174#webpage\"},\"articleSection\":\"Microsoft Family, Microsoft Office, EOMONTH\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3174#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/SUMMALAI.COM\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=10#listItem\",\"name\":\"Microsoft Family\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=10#listItem\",\"position\":2,\"name\":\"Microsoft Family\",\"item\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=10\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=18#listItem\",\"name\":\"Microsoft Office\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=18#listItem\",\"position\":3,\"name\":\"Microsoft Office\",\"item\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=18\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3174#listItem\",\"name\":\"How to Use DATE and EOMONTH to Get First Day and Last Day of the Month and Year.\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=10#listItem\",\"name\":\"Microsoft Family\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3174#listItem\",\"position\":4,\"name\":\"How to Use DATE and EOMONTH to Get First Day and Last Day of the Month and Year.\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=18#listItem\",\"name\":\"Microsoft Office\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/#person\",\"name\":\"sladmin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3174#personImage\",\"url\":\"https:\\\/\\\/SUMMALAI.COM\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Summa_Logo-150x150.png\",\"width\":96,\"height\":96,\"caption\":\"sladmin\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?author=2#author\",\"url\":\"https:\\\/\\\/SUMMALAI.COM\\\/?author=2\",\"name\":\"Summa Lai\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3174#authorImage\",\"url\":\"https:\\\/\\\/SUMMALAI.COM\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Summa_Logo-150x150.png\",\"width\":96,\"height\":96,\"caption\":\"Summa Lai\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3174#webpage\",\"url\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3174\",\"name\":\"How to Use DATE and EOMONTH to Get First Day and Last Day of the Month and Year. | Summa Lai\",\"description\":\"On this page, you will find some formulas to calculate specific days automatically. Building specific dates, such as the first or last day, is always a very complex task, in Excel or any other software. The function TODAY has been used in all the examples but you can replace it with your own date value.\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3174#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?author=2#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?author=2#author\"},\"datePublished\":\"2021-03-28T18:38:08-07:00\",\"dateModified\":\"2021-03-31T08:53:37-07:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/#website\",\"url\":\"https:\\\/\\\/SUMMALAI.COM\\\/\",\"name\":\"Summa Lai\",\"description\":\"Never Stop Learning, Building a Little Wiki...\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"How to Use DATE and EOMONTH to Get First Day and Last Day of the Month and Year. | Summa Lai","description":"On this page, you will find some formulas to calculate specific days automatically. Building specific dates, such as the first or last day, is always a very complex task, in Excel or any other software. The function TODAY has been used in all the examples but you can replace it with your own date value.","canonical_url":"https:\/\/SUMMALAI.COM\/?p=3174","robots":"max-image-preview:large","keywords":"eomonth,microsoft family,microsoft office","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/SUMMALAI.COM\/?p=3174#article","name":"How to Use DATE and EOMONTH to Get First Day and Last Day of the Month and Year. | Summa Lai","headline":"How to Use DATE and EOMONTH to Get First Day and Last Day of the Month and Year.","author":{"@id":"https:\/\/SUMMALAI.COM\/?author=2#author"},"publisher":{"@id":"https:\/\/SUMMALAI.COM\/#person"},"image":{"@type":"ImageObject","url":"https:\/\/www.automateexcel.com\/excel\/wp-content\/uploads\/2020\/04\/Last-day-of-Previous-Month.png","@id":"https:\/\/SUMMALAI.COM\/?p=3174\/#articleImage"},"datePublished":"2021-03-28T18:38:08-07:00","dateModified":"2021-03-31T08:53:37-07:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/SUMMALAI.COM\/?p=3174#webpage"},"isPartOf":{"@id":"https:\/\/SUMMALAI.COM\/?p=3174#webpage"},"articleSection":"Microsoft Family, Microsoft Office, EOMONTH"},{"@type":"BreadcrumbList","@id":"https:\/\/SUMMALAI.COM\/?p=3174#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM#listItem","position":1,"name":"Home","item":"https:\/\/SUMMALAI.COM","nextItem":{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?cat=10#listItem","name":"Microsoft Family"}},{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?cat=10#listItem","position":2,"name":"Microsoft Family","item":"https:\/\/SUMMALAI.COM\/?cat=10","nextItem":{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?cat=18#listItem","name":"Microsoft Office"},"previousItem":{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?cat=18#listItem","position":3,"name":"Microsoft Office","item":"https:\/\/SUMMALAI.COM\/?cat=18","nextItem":{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?p=3174#listItem","name":"How to Use DATE and EOMONTH to Get First Day and Last Day of the Month and Year."},"previousItem":{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?cat=10#listItem","name":"Microsoft Family"}},{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?p=3174#listItem","position":4,"name":"How to Use DATE and EOMONTH to Get First Day and Last Day of the Month and Year.","previousItem":{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?cat=18#listItem","name":"Microsoft Office"}}]},{"@type":"Person","@id":"https:\/\/SUMMALAI.COM\/#person","name":"sladmin","image":{"@type":"ImageObject","@id":"https:\/\/SUMMALAI.COM\/?p=3174#personImage","url":"https:\/\/SUMMALAI.COM\/wp-content\/uploads\/2020\/05\/Summa_Logo-150x150.png","width":96,"height":96,"caption":"sladmin"}},{"@type":"Person","@id":"https:\/\/SUMMALAI.COM\/?author=2#author","url":"https:\/\/SUMMALAI.COM\/?author=2","name":"Summa Lai","image":{"@type":"ImageObject","@id":"https:\/\/SUMMALAI.COM\/?p=3174#authorImage","url":"https:\/\/SUMMALAI.COM\/wp-content\/uploads\/2020\/05\/Summa_Logo-150x150.png","width":96,"height":96,"caption":"Summa Lai"}},{"@type":"WebPage","@id":"https:\/\/SUMMALAI.COM\/?p=3174#webpage","url":"https:\/\/SUMMALAI.COM\/?p=3174","name":"How to Use DATE and EOMONTH to Get First Day and Last Day of the Month and Year. | Summa Lai","description":"On this page, you will find some formulas to calculate specific days automatically. Building specific dates, such as the first or last day, is always a very complex task, in Excel or any other software. The function TODAY has been used in all the examples but you can replace it with your own date value.","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/SUMMALAI.COM\/#website"},"breadcrumb":{"@id":"https:\/\/SUMMALAI.COM\/?p=3174#breadcrumblist"},"author":{"@id":"https:\/\/SUMMALAI.COM\/?author=2#author"},"creator":{"@id":"https:\/\/SUMMALAI.COM\/?author=2#author"},"datePublished":"2021-03-28T18:38:08-07:00","dateModified":"2021-03-31T08:53:37-07:00"},{"@type":"WebSite","@id":"https:\/\/SUMMALAI.COM\/#website","url":"https:\/\/SUMMALAI.COM\/","name":"Summa Lai","description":"Never Stop Learning, Building a Little Wiki...","inLanguage":"en-US","publisher":{"@id":"https:\/\/SUMMALAI.COM\/#person"}}]}},"aioseo_meta_data":{"post_id":"3174","title":null,"description":null,"keywords":[],"keyphrases":{"focus":[],"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":[],"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":{"id":"#aioseo-article-65a0c48962439","slug":"article","graphName":"Article","label":"Article","properties":{"type":"BlogPosting","name":"#post_title","headline":"#post_title","description":"#post_excerpt","image":"","keywords":"","author":{"name":"#author_name","url":"#author_url"},"dates":{"include":true,"datePublished":"","dateModified":""}}},"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"Article","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":"{\"article\":{\"articleType\":\"BlogPosting\"},\"course\":{\"name\":\"\",\"description\":\"\",\"provider\":\"\"},\"faq\":{\"pages\":[]},\"product\":{\"reviews\":[]},\"recipe\":{\"ingredients\":[],\"instructions\":[],\"keywords\":[]},\"software\":{\"reviews\":[],\"operatingSystems\":[]},\"webPage\":{\"webPageType\":\"WebPage\"}}","pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":{"businessInfo":{"name":"","urls":{"website":"","aboutPage":"","contactPage":""},"address":{"line1":"","line2":"","zip":"","city":"","state":"","country":""},"contact":{"email":"","phone":"","fax":""},"ids":{"vatID":"","taxID":"","chamberID":""},"payment":{"priceIndication":"","currenciesAccepted":"","methodsAccepted":""},"areaServed":""},"openingHours":{"show":false,"closedLabel":"","open24h":false,"open24hLabel":"","open247":false,"use24hFormat":false,"twoSets":false,"timezone":"","hours":[]}},"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2021-03-29 01:26:25","updated":"2024-01-12 04:48:09","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/SUMMALAI.COM\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/SUMMALAI.COM\/?cat=10\" title=\"Microsoft Family\">Microsoft Family<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/SUMMALAI.COM\/?cat=18\" title=\"Microsoft Office\">Microsoft Office<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tHow to Use DATE and EOMONTH to Get First Day and Last Day of the Month and Year.\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/SUMMALAI.COM"},{"label":"Microsoft Family","link":"https:\/\/SUMMALAI.COM\/?cat=10"},{"label":"Microsoft Office","link":"https:\/\/SUMMALAI.COM\/?cat=18"},{"label":"How to Use DATE and EOMONTH to Get First Day and Last Day of the Month and Year.","link":"https:\/\/SUMMALAI.COM\/?p=3174"}],"_links":{"self":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3174","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3174"}],"version-history":[{"count":3,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3174\/revisions"}],"predecessor-version":[{"id":3183,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3174\/revisions\/3183"}],"wp:attachment":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3174"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3174"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}