If you wanted to install this validation in A1 to A20,
Select A1:A20, then:
<Data> <Validation>
Expand the "Allow" box, and choose "Custom".
Enter this into the "Formula box:
=WEEKDAY(A1,2)>5
Then <OK>
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
Is it possible to validate a cell so that only a date which is a saturday or
a sunday can be entered?
please help me,its for college coursework
thanks
sam