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.
|