Make an Awesome Dynamic Calendar in Excel

Make a dynamic calendar in Excel (3 different methods)

In this video I'll show you 3 ways to create a dynamic calendar in Excel. First we'l use Excel's built in templates to create a new tab for every month. Second, we'll build a calendar from scratch in Excel using formulas such as the sequence, weekday, and weeknum. We'll then make the calendar dynamic with dropdown lists. Finally, we'll use the free add-ins. More specifically we'll use the mini calendar excel add-in. By the end of the video, you'll have made full page calendars by month, as well as dynamic calendar where you can switch the month, year, and week number.

LEARN:

SOCIALS:

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ Excel Calendar Templates
1:55​ - Excel Calendar with Formulas
8:26​ - Making it Dynamic
9:11​ - Adding Conditional Formatting
10:11​ - Calendar Free Add-in

[giuseppeantonioferro]

Complimenti, i tuoi tutorial sono tutti molto interessanti. Ti seguo da Torino, Italia, metto i sottotitoli perché non riesco a seguire tutto in inglese ma riesco comunque ad apprendere quello che fai. Ancora complimenti, anche per il tuo modo di spiegare, calmo, preciso e sempre con un sorriso. Grazie per quello che fai

[Excelambda]

Great video!! Cool methods!!✌🏼 One missing, so, for fun, a single cell lambda method, can be called anywhere, and does everything, (includes format):
Define function called "YMD" , Year Month Day, a composed lambda of these parameters: YMD([y], [m], [d])([w]), where:
[y]: year : numeric, (2024 or 24), if omitted =current year
[m]: month : numeric or string ( 6, 06, "jun", "june" ), if omitted = current month
[d]: day : numeric, if omitted =current day
[w] : week num argument, if omitted wk.nr. does not show, if w=1, wk.nr. will show. Note : the reference dates for the wk.nr. calc is the column that includes first day of month.

=LAMBDA([y], [m], [d],
LAMBDA([w],
LET(
n, NOW(),
f, --(1 & "-" & IF(m = "", MONTH(n), m) & "-" & IF(y, y, YEAR(n))),
h, IF(d, d, DAY(n)) + f - 1,
x, f - WEEKDAY(f, 3) - 14,
a, SEQUENCE(8, 7, x),
t, " " & TEXT(a, "d"),
i, IFS(
a > EOMONTH(f, 0),
t,
a = h,
TEXT(a, "| dd |"),
a >= f,
TEXT(a, "- dd -"),
a >= x + 14,
t,
a >= x + 7,
TEXT(a, "|ddd|"),
a = x + 1,
YEAR(f),
a = x,
TEXT(f, "mmm"),
1,
""
),
IF(w, HSTACK(VSTACK({""; "Wk"}, WEEKNUM(f + 7 * SEQUENCE(6, , 0), 2) & ""), i), i)
)
)
)

Examples:
- calling "today"
=YMD()()
- calling "today" + wk.nr.
=YMD()(1)
- same date as current date but next year (2025)
=YMD(25)()

=YMD(, "aug")(1) or =YMD(, "august")(1) or =YMD(, 8)(1)
- xmas current year
=YMD(, 12, 25)(1)
- 4th July next year (2025)
=YMD(2025, 7, 4)()

[evy_parody]

Mr Kenji, first thank you for yet another one. Secondly I would love it if you could be telling us after a lesson, where that skill you've taught us we can apply it. It'd be so helpful. Thank you

[somasundaramv]

Nice One Kenji, Loved it, the Mini Calendar in Excel

[clementverdier]

Thanks Kenji for the vid! What is the best way to be able to write down tasks for the day; would that be by adding memos? Maybe is there a better solution?

[willzinner]

didn't know the mini calendar thank you

[Aitimoney]

Question, I use Quicken for my accounts. I'm thinking about building from your Excel budget video. In this calendar video, I want to use to show my bills due for a month. Just use the start of your video that was built in, and list bills?

[patel-hu]

hello kenji, i want an advice for you, should i mention that i am preparing for cfa level-1 in my cover letter for goldman sach new summer analyst(IB)?

[Mtuji]

Hi, Writing appointments in the calenda? Do you have a meetings attendance list calendar?

[chrisvi]

Can you just guide for shift calculation ? My team is working 7 days on and 7 days off, Is there anyway for me to enter the start date of the shift and It will highlight for the total 7 days, and automate calculate the next shift ( after 7 days off), our start date of the shift always starts on Wed. TIA

[calcoleman]

The Week # seems to be ending at 31 and starting over again. Can you please fix? Thank you!

[NoName-jwuy]

There is a typo in your thumbnail image. Dyanmic