Date -- Data Validation

clock245

New Member
Joined
Aug 17, 2008
Messages
21
All,

I'm trying to create a simple data validation formula. I want one column of dates to be a starting point. So for example all Dates in Column A is when i received something. Column B is where i want users to type in what date they to action. However, i went to ensure that the user doesn't accidentally type in a date earlier than Column A. I've tried typing this into the data validation formula box, but it keeps saying that any input is restricted---the formula i'm trying to make work is =IF(a1<b13,TRUE,FALSE)

Thanks in advance for all of your help and i really appreciate your assistance!
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Nalani

Well-known Member
Joined
Apr 10, 2009
Messages
1,047
Using Excel 2007:

Activate cell B1, or where ever you want to start
1. Go to Data
2. Data Validation
3. Allow box > choose Date
4. Data box > choose greater than
5. Start date box > enter =A1
6. OK
7. Copy down if need be.

;)
 

T. Valko

Well-known Member
Joined
May 9, 2009
Messages
16,623
All,


I'm trying to create a simple data validation formula. I want one column of dates to be a starting point. So for example all Dates in Column A is when i received something. Column B is where i want users to type in what date they to action. However, i went to ensure that the user doesn't accidentally type in a date earlier than Column A. I've tried typing this into the data validation formula box, but it keeps saying that any input is restricted---the formula i'm trying to make work is =IF(a1<B13,TRUE,FALSE)< p>
Thanks in advance for all of your help and i really appreciate your assistance!
Try a formula like this...

=AND(COUNT(A1,B1)=2,B1>=A1)
 

Nalani

Well-known Member
Joined
Apr 10, 2009
Messages
1,047

ADVERTISEMENT

Biff,

I'm not following you on your formula.

Are you putting that in C1 to test A1 & B1, if B1 is greater than A1? Without using Data Validation.

I took it that the OP wanted a Validation cell in B1 to verify that B1 was not equal to or less than A1.
 

T. Valko

Well-known Member
Joined
May 9, 2009
Messages
16,623
Biff,

I'm not following you on your formula.

Are you putting that in C1 to test A1 & B1, if B1 is greater than A1? Without using Data Validation.

I took it that the OP wanted a Validation cell in B1 to verify that B1 was not equal to or less than A1.
I'm validating cell B1 to be a number (date) >= a number (date) enterd in cell A1.
 

Nalani

Well-known Member
Joined
Apr 10, 2009
Messages
1,047
Sorry Biff, had to step away for awile.

I'm validating cell B1 to be a number (date) >= a number (date) enterd in cell A1.

I still can't get it with Data Validation.

What are you putting in the fields of :
Allow:
Data:
Start date:

(or maybe something entirely different)

I am putting:
Allow: Date
Data: greater than or equal to
Start date: =AND(COUNT(A1,B1)=2,B1>=A1)

Cell A1 has today's date. No mater what date I put in B1 (before or after) I get the restricted error message.
 

T. Valko

Well-known Member
Joined
May 9, 2009
Messages
16,623
Sorry Biff, had to step away for awile.



I still can't get it with Data Validation.

What are you putting in the fields of :
Allow:
Data:
Start date:

(or maybe something entirely different)

I am putting:
Allow: Date
Data: greater than or equal to
Start date: =AND(COUNT(A1,B1)=2,B1>=A1)

Cell A1 has today's date. No mater what date I put in B1 (before or after) I get the restricted error message.
Sorry, I should have included all the steps for the settings...

Select cell B1
Data Validation
Allow: Custom
Formula: =AND(COUNT(A1,B1)=2,B1>=A1)
Uncheck Ignore blank
OK out
 

Watch MrExcel Video

Forum statistics

Threads
1,122,496
Messages
5,596,502
Members
414,073
Latest member
Contilly

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top