Hello,

I have a simple IF formula that appears not to working as expected. It
tests whether a date is between two dates and displays the message
'TODAY' or 'FALSE' if not.

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

where P44 and Q44 are valid dates.

I've used excel's Evaluate Formula dialog box which after testing the
above statement, equates to
IF(FALSE,""TODAY","FALSE")
You would expect the final evaluation would be 'FALSE' in the dialog
box, but it comes up with 'TODAY'.

Mmmmm. I'm confused, am I missing something?

Best regards from the UK,

Rob.


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