How to Make a Calendar in Excel Using Sequence
Sequence is a lot of fun to use. I walk through creating a dynamic calendar in Excel using one Sequence formula.
We also make it more user friendly by adding a dropdown selection for the month and year as well as conditional formatting.
Get Good at Spreadsheets Now: https://gotsheet.xyz/subscribe
=============================
We receive commission on purchases made through some links on this page
🗞️ Starting a Newsletter? Check out Beehiiv with a free trial and 20% off your first 3 months: https://www.beehiiv.com/partners/got-...
🖥️ Office items I can't live without:
https://amzn.to/3uqSO7Q (amazon)
🎓Course Suggestions:
► Advanced Data Analytics Certificate by Google: https://imp.i384100.net/21dWGa (coursera)
► Cybersecurity by Google: https://imp.i384100.net/VmN6oM (coursera)
► HubSpot free CRM software for sales, marketing, customer service, operations teams. https://hubspot.sjv.io/c/4186908/1001...
=============================
📲 Find me
on LinkedIn: / eamonncottrell
on Twitter: / eamonncottrell
=============================
⌚Chapter Time Markers:
00:00:00 - Demo
00:00:23 - Sequence in Action
00:00:48 - Begin Build
00:01:12 - Month Quirk
00:02:07 - Month Sequence
00:02:44 - Dropdown List
00:03:45 - Calendar Sequence
00:04:42 - Finding the first weekday
00:05:06 - WEEKDAY breakdwon
00:07:25 - Conditional Formatting
00:09:10 - Sales Invoice
#excel #calendar #gotsheet
