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)
Watch video How to make a CALENDAR formula in excel | LAMBDA online without registration, duration hours minute second in high quality. This video was added by user Karina Adcock 01 May 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 83 once and liked it 3 people.