{"id":9995,"date":"2021-12-05T02:00:13","date_gmt":"2021-12-05T02:00:13","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=9995"},"modified":"2021-12-05T02:00:31","modified_gmt":"2021-12-05T02:00:31","slug":"solved-excel-if-statement-with-date-doesnt-work-for-me","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/excel-if-statement-with-date-doesnt-work-for-me\/20295.html","title":{"rendered":"Solved Excel IF Statement With Date Doesn&#8217;t Work For Me"},"content":{"rendered":"<p>I know it&#8217;s me &#8211; I&#8217;m just not an Excel person by any stretch. So, pardon my ignorance here.<\/p>\n<p>I&#8217;m trying to get a cell to do something if the current date (=TODAY() in L5) is later than a certain date. (This worksheet is for rents on an apartment building.) For example, if today&#8217;s date is June 2, I expect that all cells for Jan, Feb &#8230; June would be calculated and contain a value, and cells for Jul &#8230; Dec would be blank.<\/p>\n<p>A sample formula reads: =IF(L5&gt;4\/1\/16,B29+B43,&#8221;&#8221;). Meaning: If the current date (L5) is greater than 4\/1, then add the values from cells B29+B43 and plunk the sum in this cell. Otherwise, put a space in the cell.<\/p>\n<p>But my fabulous date formula just doesn&#8217;t work. Every cell, no matter what date I test with, contains the value of B29+B43.<\/p>\n<p>I&#8217;ve tried various formats for the date entry (04\/01\/2016, 4\/1\/2016) but nothing works.<\/p>\n<p>Any idea what I&#8217;m doing wrong here?<\/p>\n<p>Thanks in advance &#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":15},"question-category":[53],"question_tags":[],"class_list":["post-9995","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/9995","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=9995"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=9995"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=9995"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=9995"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}