Date -- Data Validation

[clock245]

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!

 

[Nalani]

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.

 

[clock245]

haha sorry! thanks a bunch though

 

[T. Valko]

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]

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]

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]

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]

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