Forum Discussion
KH_end
Feb 24, 2026Occasional Reader
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...
PeterBartholomew1
Feb 25, 2026Silver Contributor
= 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.