Multiple Data Validations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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")
 
Back
Top