{"id":6144,"date":"2020-03-22T14:08:01","date_gmt":"2020-03-22T19:08:01","guid":{"rendered":"https:\/\/www.rushworth.us\/lisa\/?p=6144"},"modified":"2020-03-22T14:08:01","modified_gmt":"2020-03-22T19:08:01","slug":"excel-including-current-date-in-string","status":"publish","type":"post","link":"https:\/\/www.rushworth.us\/lisa\/?p=6144","title":{"rendered":"Excel &#8211; Including Current Date In String"},"content":{"rendered":"<p>Here&#8217;s a trick to include the current date in an Excel string &#8212; especially useful if you want to include the current date on a graph without having to actually <em>type<\/em> the current date each time. If you <em>just<\/em> include TODAY(), you get the integer representation. Wrap TODAY() in TEXT() and supply the formatting you want (&#8220;yyyy-mm-dd&#8221; in my example). Voila, a date like 2020-03-22 instead of 43912.<\/p>\n<p><a href=\"https:\/\/www.rushworth.us\/lisa\/?attachment_id=6146\" rel=\"attachment wp-att-6146\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-6146 size-full\" src=\"https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2020\/03\/FormattingCurrentDateInExcelString.png\" alt=\"\" width=\"551\" height=\"115\" srcset=\"https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2020\/03\/FormattingCurrentDateInExcelString.png 551w, https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2020\/03\/FormattingCurrentDateInExcelString-300x63.png 300w\" sizes=\"auto, (max-width: 551px) 100vw, 551px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here&#8217;s a trick to include the current date in an Excel string &#8212; especially useful if you want to include the current date on a graph without having to actually type the current date each time. If you just include TODAY(), you get the integer representation. Wrap TODAY() in TEXT() and supply the formatting you &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[677],"tags":[708,710,709,731],"class_list":["post-6144","post","type-post","status-publish","format-standard","hentry","category-office-365","tag-excel","tag-excel-functions","tag-microsoft-excel","tag-ms-excel"],"_links":{"self":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/6144","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6144"}],"version-history":[{"count":2,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/6144\/revisions"}],"predecessor-version":[{"id":6147,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/6144\/revisions\/6147"}],"wp:attachment":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6144"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6144"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6144"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}