Data Validation
 

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!

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!

Data Validation
 

Try this Custom Formula:

=OR(DAY(A1)=4,DAY(A1)=12,DAY(A1)=20,DAY(A1)=28)

HTH,
Elkar


"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!

Data Validation
 

oops, sorry did not read yr post carefully enough
;-(

"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!

Data Validation
 

Through a quirk of your particular scenario, this works

Data Validation for Cell A1
Allow: Custom
Formula: =MOD(DAY(A1)/4,2)=1

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"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!

Data Validation
 

.... or (presumably) =MOD(DAY(A1),8)=4 ?
--
David Biddulph

"Ron Coderre" wrote in message
...
Through a quirk of your particular scenario, this works

Data Validation for Cell A1
Allow: Custom
Formula: =MOD(DAY(A1)/4,2)=1

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"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!

Data Validation
 

Evidently, yes...that works, too!

***********
Regards,
Ron

XL2002, WinXP


"David Biddulph" wrote:

.... or (presumably) =MOD(DAY(A1),8)=4 ?
--
David Biddulph

"Ron Coderre" wrote in message
...
Through a quirk of your particular scenario, this works

Data Validation for Cell A1
Allow: Custom
Formula: =MOD(DAY(A1)/4,2)=1

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"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!