How to create a dynamic calendar in Google Sheets and Excel PART 1

How to create a dynamic Calendar in Google Sheets and Excel

Formula:
For I2 replace this with the cell of your year
For I3 replace this with the cell of your month
For I4 replace this with the cell of your start day

=LET(
yearVal, I2,
monthNum, MATCH(I3, {"January","February","March","April","May","June","July","August","September","October","November","December"}, 0),
startDayNum, MATCH(I4, {"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"}, 0),
firstOfMonth, DATE(yearVal, monthNum, 1),
startDate, firstOfMonth - (WEEKDAY(firstOfMonth, 1) - startDayNum),
SEQUENCE(6,7,startDate,1)
)

Видео How to create a dynamic calendar in Google Sheets and Excel PART 1 канала EverReachCraft