need qualifier statement
On Sun, 17 May 2009 06:30:08 -0700, Gary''s Student
wrote:
If you want the user to only pick a Saturday, then somewhere in an un-used
column, enter:
5/16/2009
5/23/2009
5/30/2009
6/6/2009
6/13/2009
6/20/2009
6/27/2009
7/4/2009
7/11/2009
7/18/2009
7/25/2009
8/1/2009
8/8/2009
8/15/2009
8/22/2009
8/29/2009
9/5/2009
9/12/2009
9/19/2009
9/26/2009
10/3/2009
10/10/2009
10/17/2009
10/24/2009
10/31/2009
11/7/2009
11/14/2009
11/21/2009
11/28/2009
12/5/2009
12/12/2009
12/19/2009
12/26/2009
and then set the Data Validation to pick from that list. That way there is
no opportunity for bad entry. The user just clicks and moves on!
No. That ties it to a single year. It should be very easy to tie
every entry to whether or not it falls on a Saturday.
|