View Single Post
  #6  
Old May 17th, 2009, 03:11 PM posted to microsoft.public.excel.worksheet.functions
Abbey Somebody
external usenet poster
 
Posts: 3
Default need qualifier statement

On Sun, 17 May 2009 07:06:25 -0700, Archimedes' Lever
wrote:

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.


OK. I used the "StrtDate" cell name (previously mentioned) in place of
"A1", and used the date format in the validation dialogs, and selected
"equal to". Now it does reject all but Saturday entries. Thank you,
Sir.