How to make a CALENDAR formula in excel | LAMBDA

preview_player
Показать описание
=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)
  1. Karina Adcock
Рекомендации по теме
Cute diy Calendar 0:00:14

Cute diy Calendar 2025 🐰

DIY paper table 0:00:18

DIY paper table calendar ✨|

How to Make 0:00:35

How to Make a Calendar using the G60 Calendar Making Kit

DIY paper calendar 0:00:16

DIY paper calendar 📆📆📆 🤗🤗 2023#shorts

DIY table calendar 0:01:00

DIY table calendar 📅 #diy #tablecalendar

Creating a Calendar 0:08:24

Creating a Calendar in Excel

Design Your Own 0:11:12

Design Your Own Personalized Calendar for Free

How to make 0:00:32

How to make a 2025 calendar the easy way using A4 paper | Simple and creative | DIY the Mommy Way

DIY Ramadan Calendar 0:02:30

DIY Ramadan Calendar | DIY Ramadan Decoration Ideas #diy #ytvideo #ramadan #decoration #craft

Subscribe if you 0:00:17

Subscribe if you like the video 😱💗 DIY mini paper Calendar 2024 - Creative Ideas Urooba

how I make 0:00:24

how I make desk calendars! #giftideas #desksetup #calendar #aestheticstatus #organization

A diy calendar 0:01:00

A diy calendar 2025😍✨ #shorts #art #diy #muktaartandcraft #craft #youtubeshortsfeatures

Create a Calendar 0:08:07

Create a Calendar in Excel - Tutorial

How to Create 0:09:50

How to Create a Calendar Template in InDesign

Desk calendar diy/make 0:00:15

Desk calendar diy/make desk calendar from paper and cardboard/full tutorial#diycrafts #deskcalendar

Calendar making diy🤍 0:00:15

Calendar making diy🤍 |#art #diycrafts #craftideas #calendar #2025 #making #diyfriendshipday

DIY Desk Calendar 0:00:25

DIY Desk Calendar

DIY Calendar😱 #crafteraditi 0:01:00

DIY Calendar😱 #crafteraditi #shorts #youtubepartner #youtubeshorts #papercrafts #DIY @CrafterAditi...

Calendar template for 0:00:12

Calendar template for post it notes ^^ #organization #organize #3dprinting #satisfying #desk

How To Create 0:00:48

How To Create A Calendar On Canva #canvatutorial

DIY Calendar 17 0:01:00

DIY Calendar 17 #calendars #calendar #diycalebdar #crafts #handmade #diy

How the Totoro 0:00:32

How the Totoro Clay calendar works! 📆 #airdryclay #studioghibli #totoro

how to make 0:00:10

how to make your google calendar aesthetic

Diy Table Calendar 0:00:16

Diy Table Calendar 2025 🤍 #shorts #diy #art #decor #aesthetic #2025

Комментарии
Автор

Wow. To think of the formulas needed to replicate this in older Excel is mind blowing


Wonderful job explaining how to do it

patrickschardt
Автор

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

GarethKennedy-uvrf
Автор

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

toinevanderwielen
Автор

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

rimahamadeh