Excel Weekly Calendar

Опубликовано: 16 Октябрь 2024
на канале: Excel University

4,216

147

File Download: https://www.excel-university.com/yt_x...

This video shows how to create a dynamic weekly calendar in Excel. It enables you to set an event start and end dates and the calendar will populate for all dates of the event. Plus, you can set each event to only appear on selected days of the week, for example, only on Tuesday and Thursday.

Functions covered:
SEQUENCE
WEEKDAY
ISNUMBER
FIND
FILTER
ARRAYTOTEXT
TEXTJOIN
CHAR

Chapters in this video:
00:00 - Introduction
00:17 - Exercise 1
04:04 - Exercise 2
06:48 - Exercise 3

Subscribe here 👉 https://www.youtube.com/c/ExcelUniver... and turn on all notifications 🔔 for MS Excel time hacks that will make you more productive!

🚀 Unlock hidden Excel tricks and hacks, and become a time-saving Excel pro 👉 https://www.excel-university.com/yt_v... ⚡️🕒 Say goodbye to late nights and spreadsheet struggles!

Also, check out these videos with time saving Excel Hacks:

Watch VLOOKUP Hacks Playlist here    • VLOOKUP Hacks Series

Excel PivotTables for Beginners    • Excel PivotTables for Beginners (2025)

Watch VLOOKUP vs SUMIFS Playlist here    • VLOOKUP vs SUMIFS Series

Watch Dynamic Arrays playlist here    • Dynamic Arrays Series

Watch Treasure Maps playlist here    • Treasure Maps Series

Watch Slow to Fast playlist here    • Slow to Fast Series