Data Validation: Validate Specific Day of the Week?

T

Ted

Users will enter a date in cell D6. The date they enter must be a Monday.
How can I validate for that?

Thanks,

-Ted
 
B

Bernard Liengme

I entered dates in E1:E10. I selected E1
In the Data | Validation dialog, I used Custom and entered =WEEKDAY(E1)=2
I selected all the dates and opened Data | Validation; it offered to apply
the validation to all the cells
Done
best wishes
 
T

Ted

Perfect. Thank you.

Bernard Liengme said:
I entered dates in E1:E10. I selected E1
In the Data | Validation dialog, I used Custom and entered =WEEKDAY(E1)=2
I selected all the dates and opened Data | Validation; it offered to apply
the validation to all the cells
Done
best wishes
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Testing a cell value for a specific weekday. 4
How to automate update on weekly reports spreadsheet 0
Date Validation 3
VLOOKUP & Data Validation 0
IF validation for time totaling 2
validate date entered 3
Conditinal formatting blank output cell 1
Error message needed if incorrect Date Of Birth (DOB) entered 5

Top