Try:

=IF(OR(Weekday(A1)=1,Weekday(A1)=7),B2,B1)


or if you really want to identify Sat, Sun, Mon, Tues, then.
=IF(OR(Weekday(A1)=1,Weekday(A1)=7),B2,If(Weekday( A1)<3,B1,""))

This will return a blank if it's Wed-Fri....Replace the "" with your
alternate result.


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=538639