Check if dates fall on a given quarter

Hi,

I am looking for some formulas to check if the expenditure values (Col G to N) are on the given period as defined by the start date and the complete date. So, if Feb-18 is the complete date, there should not be any expenditure values after Feb-18 quarter

On the attached sheet - For delivery, it starts on the Dec-16 So, first value on the Feb-17 quarter is NOT OK as it is intended to have the first value on the period ending Nov-16. However, value on the end of Feb-18 for end is consistent with the complete date so it (Cell L5) is OK. As one value is value the cell P5 should return False

For finalisation, both Feb-18 and Mar-18 refer to the correct quarter so should be ok. So, P7 should return as true.

Is there a way to get the formula to return TRUE and FALSE on the column P - cells P5 and P7.

You've marked this thread as solved - is it?

If all of the dates in D and E were real dates, this would work (but they are not - two are just text):

=COUNTIFS(G5:N5,"",G$1:N$1,">="&D5,G$1:N$1,"<="&E5)=0