Forum Discussion
DaveP653
Jan 03, 2024Copper Contributor
How to displayDATE for every MON, WED, FRI of each month for a full year
How to display DATE for every MON, WED, FRI of each month for a full year
Patrick2788
Jan 03, 2024Silver Contributor
Here's for 2024. You may update the year as needed:
=LET(
yr, 2024,
start, DATE(yr, 1, 1),
r, 1 + DAYS(DATE(yr, 12, 31), DATE(yr, 1, 1)),
dates, SEQUENCE(r, , start),
wday, WEEKDAY(dates, 2),
FILTER(dates, (wday = 1) + (wday = 3) + (wday = 5), 0)
)