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!
==============================================

"Sam" wrote in message
...
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