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 Mon...
excel
Formulas and Functions
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Feb 25, 2026
= MAPλ(months, CALENDARλ)

CALENDARλ = LAMBDA(monthIdx,
    LET(
        monthStart, DATE(year, monthIdx, 1),
        mGrid,      SEQUENCE(6,7,FLOOR(monthStart,7)),
        cleanMonth, IF(MONTH(mGrid)=MONTH(monthStart), DAY(mGrid), ""),
        monthTxt,   TEXT(monthStart, "MMM"),
        weekdays,   {"Mon","Tue","Wed","Thu","Fri"},
        days,       EXPAND(DROP(cleanMonth,,2),6,6,""),
        VSTACK(monthTxt, weekdays, days)
    )
);

This is based upon the m_tarler​ solution.  I set out to conform to the approach of only one formula per sheet so wanted the year calendar as one formula.