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.
--
Big Rick

Try:

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

HTH

"Big Rick" wrote:

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.
--
Big Rick

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

"Big Rick" wrote:

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.
--
Big Rick

Thank you to you both.
You are both very clever!
--
Big Rick


"Nikki" wrote:

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

"Big Rick" wrote:

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.
--
Big Rick