Thanks for the quick replies.

Just re-ran it thru the 'evaluate formula' dialog box again. Here's
what it comes up with...

IF(AND(TODAY()=P44,TODAY()<Q44),"TODAY", " ")

IF(AND(38785=38808,38785<38838),"TODAY", " ")
IF(AND(FALSE,TRUE),"TODAY", " ")
IF(AND(FALSE,"TODAY"," ")
TODAY

BTW, the P44 is 01/04/2006, Q44 is 01/05/2006 (UK dates format).
Have just noticed that the formula appears to work first time I write
it in a cell, but not when I copy it to an adjacent cell (with the
appropriate dates reflected). However, the copied cell works if I
click on the contents of that cell and click the green tick box
(without any modification to the contents).

Any further thoughts?

Many thanks,

Rob.


--
bikergsx
------------------------------------------------------------------------
bikergsx's Profile: http://www.excelforum.com/member.php...o&userid=28834
View this thread: http://www.excelforum.com/showthread...hreadid=520515