The formula should be
=IF(AND(J6<0,OR(WEEKDAY(J6)=1,WEEKDAY(J6)=7)),TRU E,FALSE


----- Supriya wrote: ----

If the entered date is either Saturday or sunday, then calculatio
should take place


=IF(OR(WEEKDAY(J6)=1,7),"True","False"

Is the above formula is correct


--
Message posted from http://www.ExcelForum.com