How to make a CALENDAR formula in excel | LAMBDA
Karina Adcock Karina Adcock
46.4K subscribers
797 views
30

 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

Share/Embed