View Single Post
  #3   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 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.