Forum Discussion

KH_end's avatar
KH_end
Occasional Reader
Feb 24, 2026

Weekday only calendar

I want to to create yearly calendars with each month in it's own block that auto populates with accurate dates (previously being done manually). The issue is I want the months to only account for Monday-Friday meaning the dates only need a 5x5 grid. Something like this:

excel
Formulas and Functions

1 Reply

  • m_tarler's avatar
    m_tarler
    Bronze Contributor
    Feb 24, 2026

    I will send file via private message.

    Here is the lambda I created:

    =LAMBDA(start_of_month,LET(
mGrid,SEQUENCE(5,7,start_of_month+1-WEEKDAY(start_of_month,16)),
cleanMonth,IFS(mGrid<start_of_month,"",mGrid>EOMONTH(start_of_month,0),"",1,DAY(mGrid)),
DROP(cleanMonth,,2)))

    I gave a much more complete answer but this forum deleted it.  Feel free to ask me questions.