Validation of Cell Based on Checkbox

**arevelis** · 05-02-2012, 12:49 PM

Hi -

I am creating a form and am trying to validate a specific cell based on a check box.

I have 3 items: Today's Date, Due Date, and Rush order.

When the user enters today's date, they must enter a due date that is minimally 2 days later. ex( if today's date is 5/2/12, due date must be at least 5/4/2012 )

I have validated Today's Date cell as: Today's >= TODAY()

I have validated Due Date as: > Today's Date +1

If the user does not fill in a date 2 days from today's date they get a message to correct. I would like to allow them to check a Rush Order box, and if checked allow them to enter a date that is equal to today's date or the next day. So if today's date is 5/2/12, their rush can be requested by 5/2/2012 or 5/3/2012.

Can anyone help with this??

Thanks!

**dilipandey** · 05-02-2012, 01:01 PM

Hi arevelis,

Welcome to the forum.

For Rush, you can use the validation as :-

=AND(F13-today()>=1,F13-today()<=2)

F13 is the cell where this validation is applied

Regards,
DILIPandey

<click on below 'star' if this helps>

**arevelis** · 05-04-2012, 11:49 AM

Thanks for the help. This got me in the right direction, but I ended up using a different solution...

I create a checkbox and linked it to an unused cell in the worksheet. This read "TRUE" if checked and "FALSE" if unchecked.

I then entered the validation text to my DueDate cell as:

=IF(V11=TRUE, O7-1, O7+1)

V11 was the linked cell to the checkbox. O7 is the cell where the user enters the date they fill out the form.

Again, Thanks for your help!