Multiple Data Validations
 

Is there a way to set up a data validation where a different message would
pop up depending on the date you entered in the cell? What I'm trying to do
is if a request date is within two weeks of the todays date(entered on a
different cell), then it will tell you to go to step 4. If it's after two
weeks from today's date , then it will tell you to go to step 6. Know how to
do with one date range using data validation.

Is this possible?

Multiple Data Validations
 

Personally, I think I'd use a helper cell with a formula in it that determines
the message and displays it.

within two weeks???
=if(abs(today()-a1)<=14,"message1","message2")

Supe wrote:

Is there a way to set up a data validation where a different message would
pop up depending on the date you entered in the cell? What I'm trying to do
is if a request date is within two weeks of the todays date(entered on a
different cell), then it will tell you to go to step 4. If it's after two
weeks from today's date , then it will tell you to go to step 6. Know how to
do with one date range using data validation.

Is this possible?

--

Dave Peterson