Published On May 1, 2024
=LAMBDA(date,VSTACK(HSTACK(TEXT(date,"mmmm"),YEAR(date),"","","","",""),
{"Mon","Tue","Wed","Thu","Fri","Sat","Sun"},
LET(first,EOMONTH(date,-1)+1,
seq,SEQUENCE(6,7,first-WEEKDAY(first,3),1),
IF(MONTH(seq)=MONTH(date),TEXT(seq,"d"),""))))(B2)
show more