Thread: Data Validation: Validate Specific Day of the Week?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme[_2_] Bernard Liengme[_2_] is offline
external usenet poster
  
Posts: 563
Default Data Validation: Validate Specific Day of the Week?
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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

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

Thanks,

-Ted

Reply With QuoteReply With Quote