Hi!

The problem is that if D1 = paid (or any text value for that matter), it
causes the WEEKDAY function to error with #VALUE!.

Try this:

=OR(TEXT(D1,"ddd")="Sat",TEXT(D1,"ddd")="Sun",D1=" Paid")

Biff

"jnk101" wrote in
message ...

Hi,

I'm trying to validate cell D1 so only weekend dates are approved *or*
the text Paid. I have tried this in the custom formula box:

=OR(WEEKDAY(D1,2)5,D1="Paid")

This accepts weekend dates but for some reason won't accept the text
Paid.

What am I doing wrong?


--
jnk101
------------------------------------------------------------------------
jnk101's Profile:
http://www.excelforum.com/member.php...o&userid=27521
View this thread: http://www.excelforum.com/showthread...hreadid=470377