Thread: Data Validation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa Jarek Kujawa is offline
external usenet poster
 
Posts: 6
Default Data Validation

one way is to put those dates in different cells (e.g. A1:A4):

select some other cell
select Data-Data validation-List-Source-mouse select or input manually
range A1:A4

then copy the cell to appropriate range

HIH

"Jean" wrote:

Hi,

I am trying to limit data entries to only 4 days for a billing cycle of:
4,12,20,28, meaning I can enter a date that it can be 3/4/2006 or 2/12/2005
or 6/28/2007 or 8/20/2010 (just limit days in a date to these 4 days, month
and year can be any month and any year),

Help please :)

Thanks a lot!