Hi all,

So, I've got a worksheet with a bunch of projects and dates that relate to it in various columns. From this worksheet I have another that displays only those projects that have an opening date within two weeks of today using this formula:

=IF(AND('Programme (High Level)'!$J6<=Control!$D$2, 'Programme (High Level)'!$J6>=Control!$C$2),'Programme (High Level)'!A6,"")

Control!$C$2 is today's date
Control!$D$2 is the date in two weeks.
Programme (High Level)'!$J6 is the opening date of the project.

So this is working fine. Now, I've been asked to extend this function so that if ANY of the dates come within two weeks the project is displayed in my second worksheet.

I've started trying to add the OR function to implement this, but keep getting caught up in the syntax. So aswell as J6 - I also need to include dates in L6, N6, P6, Q6, S6, U6, W6 and X6.

I tried something like this:

=IF(OR(AND('Programme (High Level)'!$J6<=Control!$D$2, 'Programme (High Level)'!$J6>=Control!$C$2)), AND('Programme (High Level)'!$L6<=Control!$D$2, 'Programme (High Level)'!$L6>=Control!$C$2)), AND('Programme (High Level)'!$N6<=Control!$D$2, 'Programme (High Level)'!$N6>=Control!$C$2))...etc

This doesn't seem to be working though, and oh, how it hurts the eyes!

Can anyone suggest where I going wrong, or a simpler formula to get the result I need.

TIA,

SamuelT