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?