Login Page - Create Account

Support Board


Date/Time: Sun, 24 Nov 2024 20:20:07 +0000



Post From: How to draw a vertical line at 3rd friday every month?

[2022-05-05 03:32:21]
Sawtooth - Posts: 4120
I would use another instance of the color background study.

This formula will work for 2022:
=OR(
BARDATE=WORKDAY(EOMONTH(DATE(2022,3,1),0)+1,-1),
BARDATE=WORKDAY(EOMONTH(DATE(2022,6,1),0)+1,-1),
BARDATE=WORKDAY(EOMONTH(DATE(2022,9,1),0)+1,-1),
BARDATE=WORKDAY(EOMONTH(DATE(2022,12,1),0)+1,-1))

You'll need to edit the dates as needed.