Make Monthly Calendar in Excel 365 Step-by-Step
HTML-код
- Опубликовано: 15 июл 2024
- ✅ 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 RUclips: ruclips.net/user/contextu...
#ContexturesExcelTips #ExcelQuickTips
This is perfect!! Thank you, I finally was able to get what I was looking for.
You're welcome, Elizabeth, and I'm glad the video had what you were looking for!
What a great idea. Tori it was easy to follow and it was broken down into smaller steps. Wonderful job
Thank you, Patrick, and I'm glad you found the video helpful! Thanks for your encouraging comments!
This was agreat help, thank you.
You're welcome, Richard, and thanks for your comment!
Hi, what if we want to then add events to the calendar? Or checkboxes with events that have been completed?
I've added an event calendar that you can download on this page on my Contextures site:
www.contextures.com/excelcalendarformulas.html
Is there a way to make the sequence formula skip columns?
Not that I know of! A different type of formula might do what you need
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. :(
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
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
hi - is it possible to make a video for data entry Fields userform with scanned pdf display
Thanks for asking, but I don't have any examples for that. Perhaps you can find another video on that topic.
why does the textjoin formula wont work for me? :(
TEXTJOIN is one of the newer functions, available in Excel 365, Excel 2019 and later. Maybe you're using an earlier version?
Hi
Hi! It's nice to see you here again!