{"id":3300,"date":"2021-11-03T12:15:26","date_gmt":"2021-11-03T12:15:26","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=3300"},"modified":"2021-11-03T12:15:57","modified_gmt":"2021-11-03T12:15:57","slug":"help-writing-an-if-statement-using-date-ranges","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/help-writing-an-if-statement-using-date-ranges\/20030.html","title":{"rendered":"Help Writing An IF Statement Using Date Ranges"},"content":{"rendered":"<p>Formula is in Cell A10<br \/>\nFormula needs to look at Cell W10 and if the date in W10 is between 2\/12\/16 and 3\/20\/16 then it returns &#8220;528\/522&#8221;, but if the value of W10 is between 3\/21\/16 and 6\/18\/16, then it returns &#8220;567\/565&#8221;, etc. I can&#8217;t figure out the syntax<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":13},"question-category":[53],"question_tags":[],"class_list":["post-3300","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\/3300","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\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=3300"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=3300"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=3300"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=3300"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}