Data Validation

B

Big Rick

Hello Folks

I would like to have some data validation in a cell that will only only me
to have a date entered beginning with the 1st of any month of any year. (e.g.
1/1/06 or 1/6/09)
Any help would be greatly appreciated

Your help is and always has been very much appreciated.
Thanking you in anticipation.
 
T

Toppers

Try:

With cell e.g A1 formatted as DATE, with Data Validation==>Custom=>Formula
is: =Day(A1)=1

HTH
 
N

Nikki

assuming your date is in cell A#, go to data-->validation--->select
setting--> allow date-->Data equal-->type =DAY(A3)=1 in the formula box. Now
if you type 6/2/06 you will get an error message
 
Top