Hello - any help!! Going bald ripping hair out trying to resolve!
I want to return a value "Q1" if a date falls between 2 dates, another value "Q2" if a date between 2 dates and so on an so forth until each date value is evaluated to see if it falls into the dates set for Q3 and Q4. But I'm stuck as WHEN one a logic is seen to be 'true' EXCEL stops evaluating if OTHER conditions are ALSO met. I'm stuck, can anyone help?