Forum Discussion

DaveP653's avatar
DaveP653
Copper Contributor
Jan 03, 2024

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

  • Patrick2788's avatar
    Patrick2788
    Silver 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)
    )