Hi guys,

Thanks for getting back to me.

So - today's date is todays date: =TODAY()
And today's date is less than the due date.

All the projects have various phases, which fall over a three month
period (or thereabouts). What I want to show is that whenever a due
date for one of the phases is within two weeks of today, then it shows
up on my 'Two Week Overview'. The formula will actually go in a number
of cells - I just need to get it right and then drag it around!

My thinking behind using IF(OR(AND... was that I could say IF the date
in this column OR this column OR this column is between x date AND y
date (i.e. the two week period) then display the cell value.

Any more clarification, let me know.

Cheers,

SamuelT


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