How to make a CALENDAR formula in excel | LAMBDA

=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)

[@patrickschardt7724]

Wow. To think of the formulas needed to replicate this in older Excel is mind blowing Wonderful job explaining how to do it

[@GarethKennedy-uv9rf]

WoW. That was great, a lot goes in - great job!

[@toinevanderwielen9508]

Super! Great stuff. Thank you very much for this video. How would you put in week numbers?

[@rimahamadeh2706]

Hello. ANy advice how to alter this formula to work as good as it is on excel, on google sheets?