Data Validation: allow any Monday-only date

Hello,
I need a formula in Data Validation that restricts the entry of a date to a/any Monday.

The entry in the screenshot below allows no "mm/dd" entry whatsoever... shown only to help explain what is desired.  Thanks in advance...
  data validation dialogue box
Berry MetzgerLean process improvement consultantAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
telyni19Connect With a Mentor Commented:
Change the "Allow" choice to "Formula" and enter this:
=WEEKDAY(A1)=2

Where A1 should be the first cell in your range for data validation.
0
 
Berry MetzgerLean process improvement consultantAuthor Commented:
Thanks.  That did it!
0
All Courses

From novice to tech pro — start learning today.