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
1 Reply
- Patrick2788Silver 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) )