Make Monthly Calendar in Excel 365 Step-by-Step

Подписаться 63 тыс.

Просмотров 7 тыс.

50% 1

✅ Get the sample Excel file to follow along: myctx.link/CAL
Create a printable monthly Excel calendar, based on a few short formulas. Change the year or month number, to update the calendar, with that month's holidays highlighted.
Note: This workbook uses functions that are available in Excel 365, and in Excel for the Web.
💡 Related Links 💡
Printable Excel Calendar Select Year Month ► myctx.link/CAL
Fix Excel Dates That Won't Change Format ► myctx.link/FixDates
🔴 Related Excel Videos 🔴
How to Split Date and Time in Excel ► • How to Split Date and ...
Excel Dates Won't Change Format ► • How to Fix Excel Dates...
⏰ Video Timeline ⏰
00:00 Introduction
00:13 Start Calendar
00:58 Year and Month
01:25 Date Formulas
02:20 Month End
02:50 Sunday Formula
04:56 Calendar Formula
05:32 Calendar Format
06:15 Calendar Heading
07:13 Hide Dates
08:35 Highlight Holidays
09:48 Highlight Holidays
10:22 Get the Excel File
Instructor: Debra Dalgleish, Contextures Inc.
More Excel Tips and Tutorials: www.contextures.com/tiptech.html
Subscribe to Contextures RU-vid: ru-vid.com...
#ContexturesExcelTips #ExcelQuickTips

Опубликовано:

5 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 19

@elizabethguerrero625 2 месяца назад

This is perfect!! Thank you, I finally was able to get what I was looking for.

@contextures 2 месяца назад

You're welcome, Elizabeth, and I'm glad the video had what you were looking for!

@patrickschardt7724 Год назад

What a great idea. Tori it was easy to follow and it was broken down into smaller steps. Wonderful job

@contextures Год назад

Thank you, Patrick, and I'm glad you found the video helpful! Thanks for your encouraging comments!

@TrickyD1206 2 месяца назад

This was agreat help, thank you.

@contextures 2 месяца назад

You're welcome, Richard, and thanks for your comment!

@AmySanford-jc3di 2 месяца назад

Is there a way to make the sequence formula skip columns?

@contextures 2 месяца назад

Not that I know of! A different type of formula might do what you need

@AHunter-ir6cx 2 месяца назад

Hi, what if we want to then add events to the calendar? Or checkboxes with events that have been completed?

@contextures 2 месяца назад

I've added an event calendar that you can download on this page on my Contextures site: www.contextures.com/excelcalendarformulas.html

@eLLeBSTan 4 месяца назад

Thank you for sharing the video. I tried the Textjoin function, it works but it shows both the date (in numbers) with holiday. Not sure how to formulate the now. :(

@kiddferr3448 9 месяцев назад

Hi can we put a data like number of hours work on that date cell since it's small based from another cell or tables ? Thank you

@contextures 9 месяцев назад

In this calendar, the dates are built from a single formula, so the dates can't link to other cells. On my Contextures site, you can get a Excel holiday planner, and it has a calendar that shows daily items. www.contextures.com/Excel-Christmas-Planner.html