Need to get my formula to check dates and use relevant one

None of the formulas in your attachment reference cell B6 and only one of the 46 formulas reference B7.

Are all of the formulas supposed to point to B6 and B7? I am quite, quite confused.

You still haven't called out where you're trying to include/exclude the dates.

Are the formulas in column I:J the ones you're troubleshooting? Also, what to do when the dates are equal?

You need to choose a cell where you're applying this logic.

This formula states if G4 is between P4 and P5, use G4. <=P4 use P4, >= P5 use P5.
=IF(G4<=P4,P4,IF(G4<P5,G4,P5))

Sorry I missed it's only column G I'm wanting this to troubleshoot (tried a better explanation below). Columns I:J get the data from G and H respectively.

Thanks for the formula you suggest but is there any way to employ it into the formula in G as the only way I've managed to work it is by the addition of the formula to a new column and from here reference the array formula (column I).

If the date produced in the column G cell is earlier (<) P4 (01/09/2010) I need to use the date in P4 in the corresponding cell in G. Similarly if the Date in the Column G cell is later than (>) P5 (31/08/2013) I need to use the date from P5 in Column G cell. Should the dates lie between P4:P5 then I need to use the generated date in the cell it's generated in.
Thanks again and sorry for confusion

Then it's just as simple as plugging what you have into the formula I've written.

For every G4, plug the existing equation in its place.

G4:

=IF(G4<=$P$4,$P$4,IF(G4<$P$5,G4,$P$5)) becomes:


=IF( IF(AND(ISBLANK(C3),D4<E4,D4>F4),TREND(C4,D4,H4),(IFERROR(IF(AND(D4>E4,D5>E4),NA(),IF(AND(D4<F4,D5<F4),NA(),IF(ISBLANK(C5),TREND(C4,D4,H4),TREND(C4:C5,D4:D5,H4)))),NA()))) <=$P$4,$P$4,IF( IF(AND(ISBLANK(C3),D4<E4,D4>F4),TREND(C4,D4,H4),(IFERROR(IF(AND(D4>E4,D5>E4),NA(),IF(AND(D4<F4,D5<F4),NA(),IF(ISBLANK(C5),TREND(C4,D4,H4),TREND(C4:C5,D4:D5,H4)))),NA()))) <$P$5, IF(AND(ISBLANK(C3),D4<E4,D4>F4),TREND(C4,D4,H4),(IFERROR(IF(AND(D4>E4,D5>E4),NA(),IF(AND(D4<F4,D5<F4),NA(),IF(ISBLANK(C5),TREND(C4,D4,H4),TREND(C4:C5,D4:D5,H4)))),NA()))), $P$5))