View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Archimedes' Lever Archimedes' Lever is offline
external usenet poster
 
Posts: 63
Default need qualifier statement

On Sun, 17 May 2009 08:53:52 -0500, Dave Peterson
wrote:

If the cell is A1:

Formula is:
=WEEKDAY(A1)=7


It was accepted as a custom validation criteria, but it did not create
a cell where only Saturday dates are valid entries.