{"id":90922,"date":"2025-07-20T13:20:00","date_gmt":"2025-07-20T17:20:00","guid":{"rendered":"https:\/\/bugaluu.com\/sapiosexual\/today-function-make-the-date-static-microsoft-community\/"},"modified":"2025-07-20T13:20:00","modified_gmt":"2025-07-20T17:20:00","slug":"today-function-make-the-date-static-microsoft-community","status":"publish","type":"post","link":"https:\/\/bugaluu.com\/sapiosexual\/today-function-make-the-date-static-microsoft-community\/","title":{"rendered":"Today () function, make the date static. &#8211; Microsoft Community"},"content":{"rendered":"<p>Select the cell with the Today formula and Copy -&gt; Paste Special -&gt; Values. or Click in the required cell and use Ctrl and semicolon to enter todays date and it will be static. You could think about using Conditional formatting to highlight the cell say Red if A1 &lt;&gt; &#8220;&#8221; and required cell is also blank.<\/p>\n<p><a href=\"https:\/\/answers.microsoft.com\/en-us\/msoffice\/forum\/all\/today-function-make-the-date-static\/a0d5f1de-31cd-4a06-8301-9ec6d772f2ef\" target=\"_blank\" class=\"\">https:\/\/answers.microsoft.com\/en-us\/msoffice\/forum\/all\/today-function-make-the-date-static\/a0d5f1de-31cd-4a06-8301-9ec6d772f2ef<\/a>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Select the cell with the Today formula and Copy -&gt; Paste Special -&gt; Values. or Click in the required cell and use Ctrl and semicolon&#8230;<\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[1],"tags":[],"class_list":["post-90922","post","type-post","status-publish","format-standard","hentry","category-sapiosexual","wpcat-1-id"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/posts\/90922","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/comments?post=90922"}],"version-history":[{"count":0,"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/posts\/90922\/revisions"}],"wp:attachment":[{"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/media?parent=90922"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/categories?post=90922"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/tags?post=90922"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}