Try this:

=AND(WEEKDAY(A1,2)5,A1=TODAY())
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Sam" wrote in message
...
So what would i type as the formula if i wanted the cell to display the full
date (e.g Saturday 19th March) but wanted it to only allow a saturday or
sunday, with the date greater or equal to todays date?
Thanks Sam

"Dave Peterson" wrote:

Data|Validation|Settings tab
Allow: Custom
Formula: =WEEKDAY(A1,2)5



Sam wrote:

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

--

Dave Peterson