Forum Discussion

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 Mon...

excel

Formulas and Functions

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.