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


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=548536