Show coloum every 3rd weekday of a month etc.

Matthew_Barrett · 02-20-2022 09:12 AM

Hi!

I would like to only show/require a Colum to be filled in on lets say every third Monday of the month, what expression should i use for this?

Thanks in advance

Matt

Joseph_Seddik

Date of first day this month "1stDayThisMonth":
EOMONTH(TODAY(), -1) + 1
Weekday of Monday: (Sun: 1 to Sat: 7)
2
Date of first Monday:
[1stDayThisMonth] + MOD((2 - WEEKDAY([1stDayThisMonth]) + 7), 7)
Date of third Monday:
[1stDayThisMonth] + MOD((2 - WEEKDAY([1stDayThisMonth]) + 7), 7) + 14

Thus, the condition's expression should be:

TODAY() = EOMONTH(TODAY(), -1) + 1 + MOD((2 - WEEKDAY(EOMONTH(TODAY(), -1) + 1) + 7), 7) + 14