0

Is there a way we can check if a certain date field (say My_date) falls on the third Tuesday of any given month?

We want to prevent users from selecting certain dates throughout the year.

Improve this question
1
  • 1
    Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking.
    – Community Bot
    Aug 26, 2022 at 12:24

1 Answer 1

Reset to default
1 
AND(
   DAY( My_date ) > 14, /* 14th day of month */
   DAY( My_date ) < 22, /* 22nd day of month */
   WEEKDAY( My_date ) = 3 /* Tuesday */
)
Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .