Date validation formula (problem)

hi all,

i have problem about data validation setting formula, how get out this problem with data validation formula?

data---------------------allow input date.

01/03/2014--------------greater than or equal 01/03/2014
25/11/2014--------------greater than or equal 25/11/2014
etc...

anybody help me, will be appreciated...

thanks...

In Data validation, just enter 'date' as the allowed input, then select the start date as whatever you want the minimum to be (ie. 1/3/2014 or 25/11/2014 in your examples)

Just set the allowed value to 'greater than or equal to'

thanks but not like that, i mean,

for date criteria (ie.01/03/2014) must be the same line row with criteria input (greater than or equal 01/03/2014)
example;
---for 25/11/2014----allowed date ----25/11/2014 to 30/11/2014.

Ford, thanks but not work...

for date 25/11/2014, date of range to allow (25/11/2014 - 30/11/2014)
for date 01/03/2014, date of range to allow (01/03/2014 - 31/03/2014)
for date 12/12/2014, date of range to allow (12/12/2014 - 31/12/2014)
etc...

adjusted with day of month....

put the lower and upper dates their own cells...thanks Ford

your formula make me confuse,
=AND(A1>=B1,A1<=C1), please, check it.

assuming, all my data in col. a, and col. b is as target...why you show cell "b1,c1"??

Jhon, where is your end date? Kalau tanggal mulai adalah di column A, dimana tanggal akhir? (minta maaf, aka tak pakai bahasa selama 3 tahun!)

just only start date, end of date based on day of month,
i means if January---end date is 31/01, etc...(tanggal akhir adalah tanggal akhir setiap bulan, tergantung dari bulannya apa)...

Kalau begitu, use Bebo's data validation suggestion

sorry "end of date based on end day of each month"...

Bebo, thanks but not full work

here my criteria;

03/05/2014-------------should be date to allow entry-------range of 03/05/204 to 31/05/2014.....

Bebo, my expected result not must be 31/05/2014, but range from 03/05/2014 up to 31/05/2014 (allowed entry date)

here my sample workbook...

please, see it....

Hi John,

Try this.

Hi,cffndncr...it was help me, work like a charm...

thanks....(susah bener meng-eja nama kamu)

BIEN MERCI!!!!!

for Bebo, thanks too...i am missing it...

Hi Jhon,

If this takes care of your problem, please mark the thread as [SOLVED]. You should also add rep to Bebo, who came up with the solution